Date/time query

  • Thread starter Thread starter James
  • Start date Start date
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?
 
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
 
Back
Top