GuideCalculationsDateOverview
Calculations
Date

Date calculations

ADD_DAY
Adding days to a date
ADD_DAY([Created On], 1)
ADD_HOUR
Adding hours to a date
ADD_HOUR([Created On], 1)
ADD_MINUTE
Adding minutes to a date
ADD_MINUTE([Created On], 1)
ADD_MONTH
Adding months to a date
ADD_MONTH([Created On], 1)
ADD_WEEK
Adding weeks to a date
ADD_WEEK([Created On], 1)
ADD_YEAR
Adding years to a date
ADD_YEAR([Created On], 1)
AUTO
Returns the auto detected date grouping period
AUTO([Date])
DATE
Converts a provided date string in a known format to a date value
DATE('3 Sep 2018')
DAY
Returns the date of the expression (DD MMM YYYY)
DAY([Date])
HOUR
Returns the date, truncating seconds of the expression
HOUR([Date])
MINUTE
Returns the date, truncating seconds of the expression
MINUTE([Date])
MONTH
Returns the month of the expression
MONTH([Date])
NOW
Returns the current date as date value
DAY(NOW())
QUARTER
Returns the quarter of the expression
QUARTER([Date])
TIMELINE
Special date function used for grouping data by date period
TIMELINE([Start Date, End Date])
WEEK
Returns the week of the expression
WEEK([Date])
YEAR
Returns the year of the expression
YEAR([Date])