Using the Named Search: Forecast Series Date Range User Property

Use this user property when querying the revenue records to include in the current forecast. The default is to include all records, in the range specified by the forecast.

The value of the Named Search: Forecast Series Date Range user property must be a valid search specification. The search specification (as well as the Auto and Assoc search specifications) can use special variables as defined in the Forecast Series and Forecast Series Date business components. For example, if the default value of Named Search: Forecast Series Date Range is:

[Date] >= ‘&FCST_DATE_LOWER_BOUND’ and [Date] <= ‘&FCST_END_DATE’

then values between the Date - Lower Bound field and the End Date field of the Forecast 2000 -- Forecast Series Date business component are returned. In such a case:

  • The variable &FCST_DATE_LOWER_ BOUND represents the Date - Lower Bound field, which is the History View Date if it has a value.

  • If History View Date does not have a value, the Date - Lower Bound field is the History Edit date if it has a value, or the Start Date if the History Edit date does not have a value.

You can deactivate and modify the values of the Named Search: Forecast Series Date Range user property; however, you cannot create new instances of it.

Note: If you deactivate the Named Search: Forecast Series Date Range user property, you can make sure that the revenues that enter the forecast are limited by date, by modifying the Auto and Assoc search specifications of the Forecast Series to include similar criteria.