Date AND Time query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day,

I am working on an issue tracker where i have a field that indicates the due
date of each issue. It is a Date/Time field formatted like this : dd-mmm-yy
h:nn. I want a query that will pull up issues due on the current day
regardless of time. Tried many commands including Date() but they all yield
blank queries. Any help would be grealty appreciated.

Best regards,
Mat
 
In the Criteria row under this date field in your query, enter:
= Date() And < (Date() + 1)
Click to expand...

That's all the date/time values between today and tomorrow.
 
Back
Top