...
- In the date field, click on the calendar icon.
- Click on "Relative Timestamp" and you will access the options on setting up a relative date.
- Click on "Close" once you are done setting the relative date.
The following values:
DAY- the date range will be calculated based on days relative to the current dateWEEK- the date range will be calculated based on weeks relative to the current dateMONTH- the date range will be calculated based on months relative to the current dateQUARTER- the date range will be calculated based on quarters relative to the current dateSEMI- the date range will be calculated based on semesters relative to the current dateYEAR- the date range will be calculated based on years relative to the current date
Optionally, the <keyword> may be followed by a + or a - sign and an integer number, representing the amount of time units. Some examples are in the following table:
| Expression | Generated Dat Range object |
|---|---|
DATERANGE("2000-01-23") | The day of January 23, 2000, starting at 00:00:00, ending at the same time |
DATERANGE("DAY") | All the current day, starting at 00:00:00, ending at 23:59:59 |
DATERANGE("DAY-1") | Day of yesterday, starting at 00:00:00, ending at 23:59:59 |
DATERANGE("DAY+1") | Day of tomorrow, starting at 00:00:00, ending at 23:59:59 |
DATERANGE("WEEK") | This week, starting* on Monday 00:00:00, ending on Sunday 23:59:59 |
DATERANGE("WEEK+1") | Next week, starting* on Monday 00:00:00, ending on Sunday 23:59:59 |
DATERANGE("WEEK-2") | 2 weeks ago, starting* on Monday 00:00:00, ending on Sunday 23:59:59 |
DATERANGE("MONTH") | This month, starting on the first day of month at 00:00:00, ending on the last day of month at 23:59:59 |
DATERANGE("MONTH-6") | 6 months ago, starting on the first day of month at 00:00:00, ending on the last day of month at 23:59:59 |
DATERANGE("MONTH+6") | 6 months later from now, starting on the first day of month at 00:00:00, ending on the last day of month at 23:59:59 |
DATERANGE("QUARTER") | this quarter, starting on the first day of quarter at 00:00:00, ending on the last day of quarter at 23:59:59 |
DATERANGE("QUARTER-10") | 10 quarters ago, starting on the first day of quarter at 00:00:00, ending on the last day of quarter at 23:59:59 |
DATERANGE("QUARTER+1") | Next quarter, starting on the first day of quarter at 00:00:00, ending on the last day of quarter at 23:59:59 |
DATERANGE("SEMI") | this semester, starting on the first day of semester at 00:00:00, ending on the last day of semester at 23:59:59 |
DATERANGE("SEMI-3") | 3 semesters ago, starting on the first day of semester at 00:00:00, ending on the last day of semester at 23:59:59 |
DATERANGE("SEMI+3") | 3 semesters later from now, starting on the first day of semester at 00:00:00, ending on the last day of semester at 23:59:59 |
DATERANGE("YEAR") | this year, starting on January 1, 00:00:00, ending on December 31, 23:59:59 |
DATERANGE("YEAR-1") | last year, starting on January 1, 00:00:00, ending on December 31, 23:59:59 |
DATERANGE("YEAR+10") | 10 years later from now, starting on January 1, 00:00:00, ending on December 31, 23:59:59 |
...