Query Using Time/Date 1

[mcgettge]

I am working with a database for a trucking operation. I need to create a query that will find late deliveries. The problem that I am having is the information is being transmitted in the following format "2/9/2004 8:07:29 AM" and I am not sure how to write the query. I need to identify any deliveries that occur after 9:00 PM, but I do not know how to do this with the date in the field also. I am trying to avoid changing the date in the query everyday. Any help would be appreciated.

 

[SteveR77]

To get the date and time fields as individual fields you can apply the Format function to your date field in a query as follows -

Date: Format([MyDate],"mm/dd/yyyy&quot
Time : Format([MyDate],"hh:nn:ss&quot


HTH,

Steve

 

[mcgettge]

Exactly what I needed, thanks.