Date calculations

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