Examples, notes, and syntax notes about using date ranges in customized expressions.
The table assumes that today’s date is Monday, November 10, 2011, using the Gregorian calendar.
|Example||Date Range||Customize Expression||Date Range of Report|
|1||Two weeks ago||cw-2w||cw-1w-1d|
|2||First 3 days of the fifth month of last year||cy-1y+4m||cy-1y+4m+2d|
|3||One full week, starting 4 weeks ago||cw-4w||cw-3w-1d|
|4||Last week in the previous year||cw-53w||cw-52w-1d|
|5||One month starting 2 months ago||cm-2m||cm-1m-1d|
|6||12 months ago in the previous year||cm-12m||cm-11m-1d|
If today is Monday, November 10, 2011, take the current date and subtract one week to obtain the last full week of October.
Add four months to the beginning of the year (the month of January) to get the month of May; add two days to the first day of the month to get the third day of the month.
Customized expressions covering most date ranges can be created by linking two terms with an operator. A term is a combination of an integer multiplier and a period abbreviation. An example of a term is 18d. An example of an operator is +.