Date/time query

J

James

I have a field that contains date and time information in the format
dd/mm/yyyy hh:mm:ss AM. I want to find all date/times within the time range
7:00 AM and 8:00 PM regardless of what date they occured on. I can't seperate
the date and time into seperate fields due to the way the system works. How
do I do it?
 
J

John W. Vinson

I have a field that contains date and time information in the format
dd/mm/yyyy hh:mm:ss AM. I want to find all date/times within the time range
7:00 AM and 8:00 PM regardless of what date they occured on. I can't seperate
the date and time into seperate fields due to the way the system works. How
do I do it?
Click to expand...

Use the TimeValue function to extract the time: put

JustTheTIme: TimeValue([yourfieldname])

in a vacant Field cell and use a criterion of
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select time only from a date/time field 8
TYPE CONVERSION 1
Date and Time 1
Formatting date gives bad results in query 2
Date Function in query 3
Access Access 2010 - Date()-1 and times in query 0
Date Calculation 1
Date Calculation 1

Top