searching a date range in two date fields
I would like to know how to create a script that searchs for a date range in two date fields and creates a report that combines all the found records in one report
That's worked a treat
Thanks for the help
You can use 2 global date fields to enter in the start and end dates for your range. Then you can have a script as such.
Enter Find Mode [ ]
Set Field [ YourDateField1; gDateStart & "..." & gDateEnd ]
New Record Request [ ]
Set Field [ YourDateField2; gDateStart & "..." & gDateEnd ]
Retrieving data ...