Filter overdue dates

[jhallcb]

Hi guys,
Happy with filtering on load but struggling to get the filter right...

Have a report that i need to show only records That are over 45 days old, tried a few different formulas but non seem to work. Anyone offer any help?

Using access 2007, uk time zone

[orange]

How about showing us your related code?

[jhallcb]

Thanks for the reply ☺
Using the filter property rather than vba, tried a few things along the lines of:
=DATEADD(day,-45,Date)
Date field is simply called date and i hve double checked it is formatted as date/time also.

[orange]

What is day?
Date is a reserved word in Access. Reserved words list

In plain English you are trying to identify records where

PaymentDueDate is more than 45 days old, or
The difference(in days) between PaymentDueDate and Today is > 45

Research the syntax and samples of Access functions here
Don't overlook Google or Bing when searching for info.

[jhallcb]

Okay so ive renamed the field from date and change day for d or dd but it keeps saying i have a missing operator?? Where should this go or what am i missing. I have googled etc im just new to access and having to learn on the job. Been thrown in at the deep end a bit

[alansidman]

Look at this link for the proper syntax. I believe that you may be missing some quotation marks from your expression.

http://www.techonthenet.com/access/f...te/dateadd.php

[jhallcb]

Thanks for the help and input guys, cracked it.

I was going about it in the wrong way trying to filter the report. I applied <=DateAdd("d",-45,Date())
to the criteria in the query instead of the report and boom works a charm.

Thanks again!