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

    Problem with Perform Find Script Step

    BillPlunkett

      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?

       

      thanks