Find records between dates in script
I have written a script to set 2 global date fields: "Start Date" and "End Date" in a Table called Report Dates.
Now I want to find records in other tables where the "Date" field falls in the range of "Start Date"..."End Date"
- I go to a layout in the other table, call it Purchases
- Showing all records
- Entering "Find" mode
- Then I am trying to Set Field "Date" to the desired range
- Then Perform Find
I cannot come up with an acceptable format for the above bold step. If I try the Find manually it works if I type 1/1/09...1/31/99
I'd appreciate some suggestions.