Date Query-show records 1 day old.

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

Guest

I have a db that needs to show all records that are over a day old. Yet my
query isn't working. It shows records that are over 2 days old. Can someone
tell me what I'm doing wrong??? Here is my query:

SELECT tblRecords.ReceivedPM
FROM tblRecords
WHERE (((tblRecords.ReceivedPM)<DateAdd("d",-1,Date())));
 
If the "over one day old" includes the current day, which mean you want to
see all dates beside the current date, then

SELECT tblRecords.ReceivedPM
FROM tblRecords
WHERE tblRecords.ReceivedPM<Date()

Or
SELECT tblRecords.ReceivedPM
FROM tblRecords
WHERE (((tblRecords.ReceivedPM)<=DateAdd("d",-1,Date())))
 
Back
Top