In FMP.12 I created 2 date fields with global storage (Start Date, End Date). I created a blank layout that prompts for input in these 2 fields. The script goes to Find mode in an existing report layout. The date range is specified with the following line:
SetField [<database>::DATE[ <database>::Start Date & "..." & <database>::End Date ]]
This yields the requested results in FMP.12, on a copy of the client's database. The client's database is on FMP.13, so I recreated the fields, layout, & script in FMP.13, but receive an error:
"The provided find criteria is not valid. Enter a valid request before proceeding."
I've tried several modifications to the script, but it seems the DATE field, rejects the references to "Start Date" and "End Date" regardless of what I try.