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?