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

How to use/create code in MS Word to calculate age? 0
Countdown macro - display settings 2
VBA - exporting serial letters to single documents 0
Date and Time 1
Issue with OLE DB Query - Date Search 0
Creating Forms 0
Select time only from a date/time field 8
Date Formats 4

Top