date search in a range
I have a script in Filemaker Pro 11. It searchs the records which are closed in the last one month. The script is as follow
Enter Find Mode
Set Field [Query::ModificationDate; GetAsText(Get ( CurrentDate )-30) & "..." & GetAsText(Get ( CurrentDate ))]
New Record Request
Set Field[Query::Closed; "Closed"]
When I run the script it ignores the modifacation date. It brings all the Closed records.
Thanks in advance