Date calculations

Returns the auto detected date grouping period
AUTO([Date]) use this sample
Converts a provided date string in a known format to a date value
DATE('3 Sep 2018') use this sample
Returns the date of the expression (DD MMM YYYY)
DAY([Date]) use this sample
Returns the date, truncating seconds of the expression
HOUR([Date]) use this sample
Returns the date, truncating seconds of the expression
MINUTE([Date]) use this sample
Returns the month of the expression
MONTH([Date]) use this sample
Returns the current date as date value
DAY(NOW()) use this sample
Returns the quarter of the expression
QUARTER([Date]) use this sample
Special date function used for grouping data by date period
TIMELINE([Start Date, End Date]) use this sample
Returns the current date as date value
DAY(TODAY()) use this sample
Returns the week of the expression
WEEK([Date]) use this sample
Returns the year of the expression
YEAR([Date]) use this sample