Subtract Dates (Access 97 SR1)

Topic

New Reply

I have a date field in a table and I would like to create an expression where you subtract today’s date from the date in the table and then the table shows only those records that are over 120 days old. How would I express today’s date in the expression? Thanks for any help.

Reply | Quote

Replies

You can use the function Date() in a query; this returns today’s date. You could use the following expression in the Criteria line for the date field:
<Date()-120
or
<DateAdd("d",-120,Date())

Reply | Quote

Thank you. That was very helpful.

Reply | Quote