Simple Date Query help

[Flora2021]

Hi, I am trying to run a query that will pull all records that match todays date or earlier. I have this working in the critera field <=Date() except it only shows records that match the dates prior to today, not also including todays date. Any suggestions? Thanks,

 

[Joe4]

What is the data type of the "Issue Log" field?
Is it a Date/Time field that has a time component to it?

If so, the issue is that "Date()" returns midnight of the current date (time would be 12:00 AM or 0:00 in military time).
So any date of today that has ANY time component will come AFTER DATE().

One way to address this is to change the criteria to something like this:

< (Date()+1)

which basically says less than midnight of tomorrow, so all dates/times of today will be included, and all date/times of tomorrow will not.

 

[Flora2021]

of the "Issue Log" field?
Is it a Date/Time field that has a time component to it?

What is the data type of the "Issue Log" field?
Is it a Date/Time field that has a time component to it?

If so, the issue is that "Date()" returns midnight of the current date (time would be 12:00 AM or 0:00 in military time).
So any date of today that has ANY time component will come AFTER DATE().

One way to address this is to change the criteria to something like this:

< (Date()+1)

which basically says less than midnight of tomorrow, so all dates/times of today will be included, and all date/times of tomorrow wi

Hi, I was using the date format. Your suggestion worked perfect. Thank you Could you help with this other issue too? On a separate query i am trying to pull records that are 14 days old including today past the date entered. I was using <Date()-14 but its pulling a single record from 5/10/22 but not records from 4/10/22 , 6/1/22, or 6/4/22. Any ideas why this one wont work? Thanks

 

[Joe4]

I was using <Date()-14 but its pulling a single record from 5/10/22 but not records from 4/10/22 , 6/1/22, or 6/4/22. Any ideas why this one wont work?

I wouldn't expect it to pull dates 6/1/22 or 6/4/22 (as those are not less than 6/1/22), but it should return date 4/10/22.
Please post a sample of your data, and the SQL code from your query (change to SQL View and copy and paste code here).