help.. date find request

Dan05 · #1 (**permalink**) 08-14-07, 17:02

i need to perform a find on records that are older than 30 days.
i have been changing the date everyday ie

<=7/14/2007), but i would like for the find to find all records older than 30 days compared to todays date.
thx.

<Ender> · #2 (**permalink**) 08-14-07, 21:48

Use a script to perform the calculated find.

Dan05 · #3 (**permalink**) 08-16-07, 10:46

I need help with the calculation

<Ender> · #4 (**permalink**) 08-16-07, 21:59

For FM7 and later, try:

Enter Find Mode[]
Set Field [ Date ; "<" & get(currentdate)-30 ]
Perform Find []