Retrieve records for previous 2880 minutes

[edmscan]

I would like to retrieve records for the previous 2880 minutes from when the query is executed. The data is stored as .. 2014-09-06 12:55:30 AM

There will be no other criteria .. don't care about days of week or anything else .. just need records fitting this criteria.

I thought it was simple .. but I cannot get it.

[Bob Fitz]

Perhaps you could apply some criteria to your query. Something like:
>=DateAdd ( "n", -2880, Date())

[June7]

What have you tried? What happened - error message, wrong results, nothing?

Would any record have date/time later than the current date/time?

You should understand that values in a date/time field not stored as you show. That is how the data can be formatted but date value is actually stored as a long integer number.

Assuming the date is stored in a date/time type field, try:

SELECT * FROM table WHERE [Date field]>DateAdd("n",-2880,Now());

[edmscan]

It works perfectly ... thanks

I used DateAdd('n',Now()-2880,Now())

Oh .. and yes I should have said displayed or formatted as bla bla.

The reason .. I used 2880 min cause I thought that would alleviate any issues with the date .. as 2880 min is 48 hours. This may change depending on my mood that day .. so by minutes was just better than 2 days.
I would have to test if that would give me the same results.

Actually .. either way gives me the exact same records. I will go with minutes.

[June7]

Why does the expression show Now()-2880?

[edmscan]

That is what I tried before .. doesn't work. Your version was correct .. mine, was wrong of course. And I learned something once again. That is never a bad thing.

So yes .. to clarify this is the right way .. SELECT * FROM table WHERE [Date field]>DateAdd("n",-2880,Now());