Help, need to return a date base on a field that is 60 days from today.

[D. Fuga]

Please help, any suggestions are welcome!

I am trying to query a table that contains records that
are based on a date field (Discrepancy noticed). I need
to be able to use this date to return a list of all
records that the discrepancy date is 60 days (or greater)
from today's date.

I may not be explaining this well, but in the end, I need
to be able to run a report that will ask for the
parameter of: "Enter today's date", and have it return a
list of records that have a "discrepancy noticed date"
that is 60 days or more old.

I am new to this and am going crazy.

Thanks,
Donna

 

[Dan]

The easiest and most automated way to do this is just to
say " < (Date()-60) " in the criteria for the Discrepancy
date field in your query. The "Date()" function always
returns the system date (in other words, today's date), so
this set of criteria is basically the same as saying you
want the discrepancy noticed dates that are prior to (less
than) 60 days ago from today (Date()-60). This way, you
wouldn't have to be prompted for today's date each time.

HTH,

Dan Sprouse