Show all records *days after date entered in date field

R

RDResearch

I need to display all records that are so many days over due (let's say 13)
according to the date entered in a date/time field. This is probably very
simple but of course Microsoft help doesn't use my terminology.
Thank you.
 
V

Van T. Dinh

SELECT *
FROM Table1
WHERE [DueDate] <= DateAdd("d", -13, Date())

HTH
Van T. Dinh
 
Top