Creating a report which includes records within a range of dates
I've been trying to create a script triggered by a button where fields from records are selected according to a range of dates. My problem is that I have already created a report where only records that contain >0 in a number field are displayed. This works fine.
I want to be able to create a new report which limits the above results to a range of dates
I have tried without success to use:
Go To Layouit[my above report) -- (sorted by date with sub-totals)
Enter Find Mode
Insert Calculated Result [Select; Table::aDate; Table::Start Date & "..." & Table::End Date
-- where Start Date and End Date are Globals, and aDate is Date field (tried Indexed and not Indexed)
Spent a lot of time going in circles ...