Skip to main content

Time period codes

All the examples are in relation to date 2017-08-26. To form a code, take a word from the left and match it with the number at the top (e.g. MONTHS-1) to get the example values.

2017-08-26

0

1

2

3

DAYS

2017-08-26 - 2017-08-26

2017-08-25 - 2017-08-26

2017-08-24 - 2017-08-26

2017-08-23 - 2017-08-26

DATE

2017-08-26 - 2017-08-26

2017-08-25 - 2017-08-25

2017-08-24 - 2017-08-24

2017-08-23 - 2017-08-23

CALWEEK

2017-08-21 - 2017-08-26

2017-08-14 - 2017-08-20

2017-08-14 - 2017-08-20

2017-08-14 - 2017-08-20

CALMONTHS

2017-09-01 - 2017-08-26

2017-08-01 - 2017-08-26

2017-07-01 - 2017-08-26

2017-06-01 - 2017-08-26

CALMONTH

2017-08-01 - 2017-08-26

2017-07-01 - 2017-07-31

2017-06-01 - 2017-06-30

2017-05-01 - 2017-05-31

MONTHS

2017-08-27 - 2017-08-26

2017-07-27 - 2017-08-26

2017-06-27 - 2017-08-26

2017-05-27 - 2017-08-26

YEARS

2017-08-27 - 2017-08-26

2016-08-27 - 2017-08-26

2015-08-27 - 2017-08-26

2014-08-27 - 2017-08-26

CALYEAR

2017-01-01 - 2017-08-26

2016-01-01 - 2016-12-31

2015-01-01 - 2015-12-31

2014-01-01 - 2014-12-31

CALQUARTER

2017-07-01 - 2017-08-26

2017-04-01 - 2017-06-30

2017-01-01 - 2017-03-31

2016-10-01 - 2016-12-31

CALHALFYEAR

2017-07-01 - 2017-08-26

2017-01-01 - 2017-06-30

2016-07-01 - 2016-12-31

2016-01-01 - 2016-06-30

CALENDYEAR

null - 2017-08-26

null - 2016-12-31

null - 2015-12-31

null - 2014-12-31

CALENDMONTH

null - 2017-08-26

null - 2017-07-31

null - 2017-06-30

null - 2017-05-31

CALENDQUARTER

null - 2017-08-26

null - 2017-06-30

null - 2017-03-31

null - 2016-12-31

CALYEARMONTH

2017-01-01 - 2017-07-31

2017-01-01 - 2017-06-30

2017-01-01 - 2017-05-31

2017-01-01 - 2017-04-30

If you add prefix R (e.g RCALMONTH), the time period code is converted to:

  1. CALMONTH, if the given date is the last day of the month

  2. MONTH, if the given date is not the last day of the month

GIVEN means from start date till end date.