Set it up exactly as above but using the script debugger, the $DateRange value was only "..."
Be sure to set up your start date and end date variables like you did in your original post. Then set your Date Range variable.
Another option is to do the following in your your script:
#Set your variables
Enter Find Mode
Set Field [ the date field; Value: $Start & "..." & $End]
Did you add (not replace) your script steps with the suggestions from BillPlunkett? You would set the $StartDate and $EndDate then set the $DateRange as suggested. You also want to untick the 'Restore' option on the find request.
change script steps as Jesse suggested... easier to read /understand your script. So, don't use Find [Restore]
I suggest you vary flukey's suggestion thus:
Set Variable [$DateRange; value: table::StartDate & "..." & value: table::EndDate ]
Perform Find [Restore] // Find Records table::ActionDate [$DateRange]
Since you apparently already have fields for entering start and end dates you don't need to create separate variables for each, just the range for your Find.
Hi. I have a personal preference for spelling out the find request in scripts (like JesseH suggested) because it makes it a lot easier when you are reviewing scripts to see at a glance what the find request is looking for. I would do it like this:
Enter Find Mode [ ]
Set Field [table::ActionDate; table::StartDate & "..." & table::EndDate"]
Perform Find [ ]