3 Replies Latest reply on Sep 3, 2012 8:09 AM by lamp

    date search in a range

    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