{[['
']]}
![](http://static.graddit.com/img/star.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaHMuOgs5YydoA0pDZm6LJM7ySDqtMpYYLeq4d5lIZSoJNEj7IKPVqR_yoePSUDzn5JPpW1BViAh_kFA0XWJbLoCyrQAlJriZtvvp6yJ_JvXszRJWVU4pu2dQIcFCcAcoCNbrHfAa4JMU/s200/Logo_SAP.gif)
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:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfy-RWgt4H9siQ6G54D13I7WLvXkPtGWAftcD-JgxCW_j64LEPyo8Zw2Z_EXcc2F7gwy_xTkEzMzDvCWvIA4I1bXLBiKKzsZijMKENXfwqTvqiv31d4YR4vI_uieRH5aaoKXY2NVEB4oI/s320/01.png)
{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