
Date range parameter
Sometimes it's necessary to filter all records in a report by a specific date range. This can be accomplished by using date parameter fields within a Select Expert formula.Option 1:
- Create a date parameter called Date_Range and allow range values in this parameter field
- Select Report, Edit Selection Formula, Record from main menu
- Enter a formula similar to the example below:

{VISIT_VISIT.STARTDATE} = {?Date Range}
Option 2:
- Create two parameters called Start Date and End Date
- Select Report, Edit Selection Formula, Record from main menu
- Enter a formula similar to the example below.
{VISIT_VISIT.STARTDATE} in {?Start Date} to {?End Date}
Post a Comment