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

    Script to filter records by date

    burbello

      Hi,

       

      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.

      Alex