Date Functions

Date functions evaluate, convert, and manipulate date and time values.

Converts date and time values to the specified time zone.

Adds a specified quantity of time to a date.

Calculates the time difference between two dates.

Formats a date value to text based on the format provided.

Converts a Unix timestamp to a date value.

Returns the value of a variable at a previous point in time (or lookback period) determined by a specified date and offset.

Extracts the specified date part from a date value.

Parses a text value in a specified format and returns a datetime value (date data type) in ISO format.

Truncates the date to the specified date part.

Returns the day of the month from a date value as a number.

Returns the last day of the month from a date value.

Returns the hour component from a date value as a number.

Determines if a date falls within a specified date range and returns True or False.

Determines if a date falls within the date range of a prior period and returns True or False.

Evaluates a specified component in a date value and returns the last datetime value of that component in ISO format.

Evaluates specified values representing year, month, and day units and returns a datetime value in ISO format.

Returns an integer representing the minute component in a specified datetime value.

Returns an integer representing the month component in a specified datetime value.

Returns the name of the month component from a specified datetime value.

Returns the current date and time using your organization's account timezone.

Returns an integer representing the quarter component in a specified datetime value.

Returns an integer representing the second component in a specified datetime value.

Returns the current date using your organization's account timezone.

Returns an integer representing the day of the week in a specified datetime value.

Returns the name of the day of the week in a specified datetime value.

Returns an integer representing the year component in a specified datetime value.

Last updated

Was this helpful?