From version 3.8.0
This page describes behaviour available from client version 3.8.0. Sites on an earlier version do not have it yet.
Fixed and relative dates in saved reports¶
When a saved report is saved on a screen that has a date range, the Save Report dialog asks how the dates should behave:
- Fixed dates: the report always covers the exact period selected when it was saved. Use it for a report that must be reproduced unchanged.
- Relative to when it's run: the dates are worked out again each time the report is opened or emailed. Use it for year to date, last 12 months, last quarter and similar.
A report with relative dates shows a clock icon beside its name, and Relative in the Dates column of the Manage saved reports page.
Screens with no date range (Rebate targeting, Product search, Data Quality and the Agreement Browser) do not ask. The Agreement Browser's quick date presets, such as Expiring This Month, are stored as the preset and are always worked out from today.
How a relative date is described¶
Each end of the range, From and To, has three parts:
- A starting point: Last closed period, Today, Start of month, End of month, Start of quarter, End of quarter, Start of year or End of year.
- A number, which moves the date forwards (positive) or back (negative). 0 means the starting point itself.
- A unit for the number: days, weeks, months, quarters or years.
The number is applied first and the result is then moved to the start or end named. So End of month, −1 months is the last day of the previous month, whatever its length.
Examples, for a report opened when the last closed period is 31 October 2026:
| From | To | Covers |
|---|---|---|
| Start of year | Last closed period | 1 January 2026 to 31 October 2026 |
| Last closed period −1 years | Last closed period | 31 October 2025 to 31 October 2026 |
| Start of quarter −1 quarters | End of quarter −1 quarters | 1 July 2026 to 30 September 2026 |
| Start of month | End of month | 1 October 2026 to 31 October 2026 |
The dialog shows Run today, this would cover … to … under each range, so the result can be checked before saving. If the From date would fall after the To date, the dialog says so and the report cannot be saved until the rule is changed.
If a quick filter was selected on a report builder when Save was chosen, the rule is filled in to match it: This YTD becomes Start of year to Last closed period, and Last 12 becomes Last closed period −1 years to Last closed period.
What "last closed period" means¶
On the Rebate Report Builder and the turnover Report Builder, dates are reckoned from the last closed period, not from today: the end of the most recent month whose turnover is due.
- On or after the site's turnover cut-off day (the 15th unless the site sets another), it is the last day of the previous month.
- Before the cut-off day, it is the last day of the month before that, because last month's turnover is not yet due.
- If that day is 29 February, 28 February is used.
Every starting point except Today is taken from that date. Start of month on 20 November 2026 is therefore 1 October 2026, the start of the last closed month, not 1 November. Choose Today for the rare report that needs the actual date.
On the Insights dashboard, the Rebate dashboard and the turnover queries list, the screen reckons from today, so Last closed period and Today give the same date there.
The comparison period¶
On the report builders, when compare with previous period is ticked, the comparison period of a relative report is the same range one year earlier. The preview in the dialog shows it.
The Rebate dashboard has three ranges¶
The Rebate dashboard has separate Rebate, Scheduled and Paid periods. Each one that has both dates filled in when the report is saved gets its own From and To rule. A period left empty is stored empty.
Why do the dates change unexpectedly¶
- The month rolled over, or the cut-off day passed. The last closed period moves forward a month on the cut-off day, and every relative date moves with it.
- The report shows its original dates and a warning. The fixed dates from the day it was saved are stored with every report. If the relative rule cannot be worked out, the screen uses those and says so.
- A quick filter is no longer selected. Saving clears the quick filter choice, because the saved dates are what the report runs on.
What relative dates are not¶
- Not a snapshot of a period. Use fixed dates for that.
- Not financial-year aware. Start of year is always 1 January.