[gvgingee]

I am trying to query records that are sixty days old or more based on an "arrival date" field and today's date. For example, if an arrival date is 12/12/2004 the query should return this record and any other that are more than 60 days old. Does anyone have a suggestion for the critera?

[Rockn]

Would the criteria for the arrival date be coming from a form field or are you just wanting to create a report based on these criteria?

[Rockn]

You can use the DateDiff Function Like this:

DateDiff("d",[ArrivalDate],Date())>=60

[OBP]

You can also the simple criteia entry for the Arrival date of <date -60

[gvgingee]

I plugged this in and it works! Thank you!

[OBP]

Which ones worked?
Can you marked this thread as "Solved" using the Thread Tools at the top of the forum page?

[gvgingee]

The DateDiff worked but I see that access converts it to the simpler formula. Thanks.