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?

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

Top