Date calculations

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 current date as date value
DAY(TODAY())
Returns the week of the expression
WEEK([Date])
Returns the year of the expression
YEAR([Date])