Show records from the last 90 days

[Celshader]

I want to perform a script on records created in the last 90 days. I would start out the script with a Perform Find command, based on the date created field, but now can I format this to show only records from the last 90 days.

I tried using the "Todays date" symbol ( // ) and subtracting 90 from it and then doing a range ( ... ) from that calculation to the current date, but that didnt seem to work (syntax error).

Edited March 10, 2010 by Guest

[mr_vodka]

Enter Find Mode []

Set Field [ DateCreation; ">=" & Get ( CurrentDate ) - 90 ) ]

Perform Find []

[Celshader]

Thanks, works great!