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, 201015 yr by Guest

Enter Find Mode []

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

Perform Find []

Thanks, works great!