DatePart

The DatePart function extracts the specified date part from a date value.

Syntax

DatePart(precision, date, [timezone])

The function has the following arguments:

Examples

DatePart("year", [Invoice Date])

Extracts the year from each value in the column of invoice dates.

DatePart("week", Date("2007-01-10 10:00:00"))

Returns 2, the week number of this date; weeks in Analytics Pro start on Sunday, by default.

DatePart("year", Date([Date]))DatePart("quarter", Date([Date]))DatePart("month", Date([Date]))
DatePart("week", Date([Date]))DatePart("day", Date([Date]))DatePart("weekday", Date([Date]))

The DatePart function returns the following values for the Date column:

DatePart("year", Date([Date]))
DatePart("hour", Date([Date]))DatePart("minute", Date([Date]))DatePart("second", Date([Date]))DatePart("millisecond", Date([Date]))DatePart("epoch", Date([Date]))