Finding Date - 90 days

[SGordon]

I have a script that runs when a user logs into a database that searches for records that have been "checked out" for more than days. The check out feature simply adds the date the record was checked out to a field and turns a selects "Yes" of a Yes/No radio button.

The problem is that I can't seem to get the search criteria right to find dates that are 90 days before the current date. I have entered the calculation as Get ( CurrentDate ) > -90 but it's not finding the correct records. Can anybody tell me what I'm doing wrong?

I would appreciate any comments. Thanks!

[Fitch]

What you'd enter in Find mode in your date field using a calc is:

"<" & Get( CurrentDate ) - 90

[SGordon]

Thanks for the quick response! I got it working now. You were extremely helpful. Thanks again!

Edited January 25, 2010 by Guest