Query on current date

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

Guest

Hello,

How would I create a query that uses the current system date for the
criteria. I do not want the user to input a date but rather just run the
query and display all matching records. The field that I have setup is using
the long time format, because a time is also entered, but I only need to look
at the date. I think DateSerial might be the way to go, but I am not sure
what the criteria would look like.

TIA
 
Hello,

How would I create a query that uses the current system date for the
criteria. I do not want the user to input a date but rather just run the
query and display all matching records. The field that I have setup is using
the long time format, because a time is also entered, but I only need to look
at the date. I think DateSerial might be the way to go, but I am not sure
what the criteria would look like.

TIA
Click to expand...

Where Format([DateField]"mm/dd/yyyy") = Format(Date(),"mm/dd/yyyy")
Or you can use:
Where Int([DateField]) = Date()
 
fredg said:
Hello,

How would I create a query that uses the current system date for the
criteria. I do not want the user to input a date but rather just run the
query and display all matching records. The field that I have setup is using
the long time format, because a time is also entered, but I only need to look
at the date. I think DateSerial might be the way to go, but I am not sure
what the criteria would look like.

TIA
Click to expand...

Where Format([DateField]"mm/dd/yyyy") = Format(Date(),"mm/dd/yyyy")
Or you can use:
Where Int([DateField]) = Date()
Click to expand...

Thanks alot Fred, that worked.
 
Back
Top