Custom Date Strategies

ReportAnywhere supports relative dates for report scheduling. This enables you to set report dates (such as the Beginning Date, End Date, Statement Date, etc.) relative to the run date of the report.

Note: Relative dates should not apply to the "run date", as "repeat options" handle that.

To enter a relative date on the report you are scheduling, right mouse click in the desired date field. When you do so, a date selection box will appear:


The custom strategy box enables you to set the report dates based on the date the report is run by the system according to the following rules:

d, m and y refer to the day, month and year of the current run date.

Each date component can be controlled separately.

Adjustments can be either relative (using + or -) or absolute (no sign).

d=last is a special case to compensate for the variable # of days in a month.

Omitting a date component is the equivalent saying 'date component=+0'  (i.e. today-->d=+0)

  A semi-colon must separate date components


Suppose you are scheduling the report to run every Sunday. To set the BEGIN DATE of the report to Monday, you could either select the "Tomorrow" option, or use custom strategy d=+1 (i.e. Monday). To set the end date to Wednesday, use the custom strategy d=+3 (i.e. Wednesday). The custom option enables a greater degree of flexibility

The following is a partial list of custom date strategy syntax and conventions.

 Option  Custom   

Yesterday d=-1

Today  d=+0

Tomorrow d=+1

PrevMMFirstDD m=-1;d=1   (first day of the previous month)

PrevMMLastDD m=-1;d=last   (last day of the previous month)

ThisMMFirstDD d=1    (first day of this month)

  d=15    (the fifteenth of this month)

ThisMMLastDD d=last    (the last day of this month)

NextMMFirstDD m=+1;d=1  (first day of next month)

NextMMLastDD  m=+1;d=last  (last day of next month)

PrevYYFirstDD y=-1;m=1;d=1  (first day of last year)

PrevYYLastDD y=-1;m=12;d=last (last day of last year)

ThisYYFirstDD m=1;d=1  (first day of this year)

  m=3;d=31  (end of first quarter, this year)

ThisYYLastDD m=12;d=31  (last day of this year)

NextYYFirstDD y=+1;m=1;d=1  (first day of next year)

NextYYLastDD y=+1;m=12;d=last (last day of next year)