date/time stamp

mcgr0199

How do I separate a date/time stamp in Access 2007? I need to be able to query for certain times of day over a period of 120 days (i.e. create a query that only gives me the data for 1pm, irrespective of the date). Any suggestions?

missinglinq

In VBA code:
DatePart("h",DateTimeField)

Or in a Query:
DatePart("h",[DateTimeField])

will retrieve the hour.

The general syntax is

DatePart("Interval",DateTimeField)

To retrieve other components, use these as the Interval

yyyy Year
q Quarter
m Month
y Day of year
d Day of Month
w Weekday
ww Week
h Hour
n Minute
s Second

date/time stamp

re: date/time stamp

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about