Need help comparing date in query or filter or??????

[NateofMT]

Hello again. I have a table that I need to pull out name, ticket_number, and date_received from. Then from this table I need to compare today's date against the (date_received) and see if more than 45 days have passed.

If more than 45 days have passed, then this needs to be printed on a report. I assume that I could use a query to do it, but I don't know how to write the formula correctly. I thought I could put date_received + 45 < now() in Criteria, but it does not like it. I have not used filters before, but maybe I need to use them here?

This topic may have been covered elsewhere, so if you want to post me a link, I would be grateful.

Thanks,
Nathan

 

[Norie]

Take a look at this piece of SQL:

SELECT Table2.[Date Assessed], DateDiff("d",[Date Assessed],Now()) AS Elapsed
FROM Table2
WHERE (((DateDiff("d",[Date Assessed],Now()))>45));

Replace Table2 and Date Assessed with your own table and field.

 

[NateofMT]

Thank you very much! It worked just perfectly! And I understood it, too.