Offset dates
The Offset date option is available when you:
Add a user-defined period.
Apply a custom period (in Financial Statements).
Set the period as part of defining a measure (in Analytics Custom mode or advanced search).
Set a defined period for a database (administrators).
The Offset date option allows you to set a date (or date range) based on today's date, so that rather than entering a fixed date range (such as Start: January 2023 and End: March 2023, you can define a dynamic date range such as year to date or last month based, so the data continues to update.
Depending on what you are doing, you will be presented with a slightly different setup window but the concept of the Offset option is the same. However, the offset settings for the Days period type are different from those of the Months and Years, as outlined below.
Use offsets for month and year-based date ranges
After selecting the Year or Month period type, select the Offset checkbox to activate the offset date setting. You can set both the start and end dates as offsets, or just one.
Enter the offset date as a number. The timeframe displays in words next to the offset box.
Examples of common offsets for months and years
The settings in the following table are ‘set-and-forget’. They are designed to work into the future, without needing to adjust them every month or every year.
Example | Time unit | Current | Previous | ||
|---|---|---|---|---|---|
Start | End | Start | End | ||
Calendar Year to Date | Month | Not Offset. Choose January and 'most recent' | Offset: 0 | Not Offset. Choose January and 'second most recent' | Offset: -12 |
Financial Year to Date | Month | Not Offset. Choose start month of financial year, e.g. July and 'most recent' | Offset: 0 | Not Offset. Choose start month of financial year, e.g. July and 'second most recent' | Offset: -12 |
Month to Date | Day | Special. Choose first day of month 0. | Offset: 0 | Special. Choose first day of month -1 (or -12) | Special. Choose match today of month -1 (or -12) |
Last month | Month | Offset: -1 | Offset: -1 |
|
|
This month | Month | Offset: 0 | Offset: 0 |
|
|
Rolling 12 months | Month | Offset: -11 | Offset: 0 |
|
|
Last three years | Year | Offset: -2 | Offset: 0 |
|
|
Use offsets for day-based date ranges
After selecting the Day period type, click the date box to display the options window, then select the tab of the option you want to use; Actual, Offset or Special:
On the Actual tab, select a specific date.
Examples of common offsets for days
Example | Current | Previous | ||
|---|---|---|---|---|
Start | End | Start | End | |
Month to Date | Special > first day of month 0. | Offset: 0 | Special > first day of month -1 (or -12) | Special > match today of month -1 (or -12) |
Today | Offset: 0 | Offset: 0 |
|
|
Yesterday | Offset: -1 | Offset: -1 |
|
|
Last 7 days | Offset: -6 | Offset: 0 |
|
|
On this page
Videos
Create your own defined period (days) - month to date
For administrators: Add a defined period using Special Offsets (days) - yesterday
Related pages