Find all records less than Specific date

[Fred in Thailand]

It's me again.

Easy one this time. Need to find all records with a due date more than 90 days before Todays date.

Tried to due set field

DueDate < Get(CurrentDate)-90

Doesn't work of course. I hate date finds. Don't understand them (except the easy ones.)

Thanks

[mr_vodka]

"<" & Get ( CurrentDate ) - 90

[Fred in Thailand]

Thanks again John

That did it.

So Simple.

Filemaker help doesn't show that as an example.

I'll learn it someday.

PS... Someday will finish The whitepaper

Edited March 25, 2008 by Guest