3 Replies Latest reply on Oct 22, 2012 1:04 PM by burbello

    Script to filter records by date




      I have a Report that as soon as it is called, it performs an script.

      However I would like add one more option to filter the records by the current month, once I have a field on the table that stores a date of the record.


      What I have now is:


      Enter Find Mode [] -- unchecked Pause option

      Set Field - calculated result: TIMETABLE::DATE > 1&"/"&Month ( Get(CurrentDate) )&"/"&Year ( Get(CurrentDate) )

      Perform Find []


      This is not working properly and I cannot see where the problem is.

      Could someone help me?


      In advance I really appreciate the help.