Date/Time Search

mreference

Registered User.
Local time
Today, 00:16
Joined
Oct 4, 2010
Messages
137
Hopefully a simple question to resolve.

I have a query that contains a complete_date including time (this is automatically datestamped when the user presses a button)

At the end of the day, I want to show how many records where processed that day but cannot figure out how to display records between 06:00am and 08:00pm on todays date.

Also, the same applies to selecting a range of dates (eg. the full week), How do I display the records that fall between Monday - Friday including the time.

regards
 
Is your stamped "Now()" ??? and actually a date field?

If so you should be able to work with dates just fine... like between Date() and Date() +1
for today starting at (default for date()) 00:00:00 and ending at 23:59:59... or in reality the next day at 00:00:00
Same would work for monday thru friday simply go Between Monday and Saturday (00:00:00) and you should get everything for monday to Friday...

If you Really need to be on top of 8PM, you can also use
Between Monday + #06:00:00# and Friday + #20:00:00#
 
Works a treat, thank you!
 

Users who are viewing this thread

Back
Top Bottom