7 Replies Latest reply on May 9, 2016 3:31 PM by macwombat

    Problem with Perform Find Script Step


      This is the 1st time I've had to use a find a script step so please bear with me a bit.


      I have a table whose records contain a date field.  I have a layout to print selected records within a user specified range.  In the table, I have 2 global fields - a start date and an end date.  A button on the form executes a script:


      Set Variable [ $Start ; value: table::StartDate ]

      Set Variable [ $End ; Value: table::EndDate ]

      Perform Find [Restore ]


      The "Specify Find Results" dialog has the following command:


           Find Records          table::ActionDate [≥ $Start & ≤ $End]


      (I've tried both & and AND) when the script executes, I get a message box that says "The provided find criteria is not valid.  Enter a valid request before proceeding"


      Yes, there ARE records in the table with the selected date range.


      What am I doing wrong?