AnsweredAssumed Answered

date search in a range

Question asked by lamp on Sep 3, 2012
Latest reply on Sep 3, 2012 by lamp

Title

date search in a range

Post

Dear All,

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"]

Perform Find[]

When I run the script it ignores the modifacation date. It brings all the Closed records.

 

Thanks in advance

Lamp

Outcomes