Criteria date and time, on just date (1 Viewer)

kirkfitz

New member
Local time
Today, 00:46
Joined
Aug 28, 2019
Messages
1
Hi there,

I have a field that has both the date and time in it:
mm/dd/yyyy hh:nn

I need to have a query that displays entries of only today's date.

any suggestions, or do I have to separate out the field (one date and one time)
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:46
Joined
May 7, 2009
Messages
19,169
you can use the expression in your query:

Datevalue([dateField]) = Date
Format([dateField],"mmddyyyy") = Format(Date, "mmddyyyy")
 

Users who are viewing this thread

Top Bottom