Data Function

A

Anthony

How can I create a query if I have alot of dates in this format '10/23/07
12:30AM' and I want to seperate it by shift like 1st shift would be between
5:00AM to 1:30PM and just look at the time and date is irelavent. Thanks
 
F

fredg

How can I create a query if I have alot of dates in this format '10/23/07
12:30AM' and I want to seperate it by shift like 1st shift would be between
5:00AM to 1:30PM and just look at the time and date is irelavent. Thanks
Click to expand...

Look up the TimeValue function in VBA help.

?TimeValue(Now())
8:47:18 AM
 
A

Anthony

I want to the time to always be set so when I run the query it will place 5AM
Shift in a colum where the time rates between 5:00AM to 1:30PM
 
Top