Versions Compared

Old Version 4

changes.mady.by.user Young White

Saved on

compared with

New Version 5

changes.mady.by.user DATABASICS, Inc.

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. In the date field, click on the calendar icon.
  2. Click on "Relative Timestamp" and you will access the options on setting up a relative date. 
  3. 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 date
  • WEEK - the date range will be calculated based on weeks relative to the current date
  • MONTH - the date range will be calculated based on months relative to the current date
  • QUARTER - the date range will be calculated based on quarters relative to the current date
  • SEMI - the date range will be calculated based on semesters relative to the current date
  • YEAR - 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:


ExpressionGenerated 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