SAP- Lesson 6

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:

1. Create a date parameter called Date_Range and allow range values in this parameter field
2. Select Report, Edit Selection Formula, Record from main menu
3. Enter a formula similar to the example below:

This example will filter all gift dates within the specified date parameter range.

{VISIT_VISIT.STARTDATE} = {?Date Range} 

Option 2:

1. Create two parameters called Start Date and End Date
2. Select Report, Edit Selection Formula, Record from main menu
3. Enter a formula similar to the example below.

This example will filter all gift dates within the specified Start and End date parameters.

{VISIT_VISIT.STARTDATE} in {?Start Date} to {?End Date}