Show all records *days after date entered in date field

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

Guest

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.
 
SELECT *
FROM Table1
WHERE [DueDate] <= DateAdd("d", -13, Date())

HTH
Van T. Dinh
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query to filter dates as entered in and if not to show N 4
Filtering records by date 2
Date Comparison 2
Query to find records after specific date and time today 10
Date/Time won't show items on first day in query 1
Access date in 1 field and day in another 3
Return all dates for 'next month' irrespective of year or day 4
Date calculation on 2 fields 5

Back
Top