Show Menu

Customized date expressions - overview

You can specify a complex date range by building a custom expression.
It is recommended that you refer to a calendar when building expressions in order to specify the number of weeks and days correctly. Excel has several built-in functions allowing you to calculate the number of days, workdays, months, and years between dates. You can use these functions in formulas to calculate other intervals, such as weeks and quarters.
To enable custom expressions
  1. On the Request Wizard: Step 1, select Rolling Dates .
  2. Enable Custom Expression .
  3. Type a special expression in the From and To fields, following the abbreviations, syntax rules, and examples given below.