Date functions
Date functions evaluate, convert, and manipulate date and time values.
| Function | Description |
|---|---|
| BusinessDays | Counts the weekdays between two dates, excluding Saturdays and Sundays. |
| ConvertTimezone | Converts date and time values to the specified time zone. |
| DateAdd | Adds a specified quantity of time to a date. |
| DateDiff | Calculates the time difference between two dates. |
| DateFormat | Formats a date value to text based on the format provided. |
| DateFromUnix | Converts a Unix timestamp to a date value. |
| DateFromUnixMs | Converts a Unix timestamp in milliseconds to a date value. |
| DateFromUnixUs | Converts a Unix timestamp in microseconds to a date value. |
| DateLookback | Returns the value of a variable at a previous point in time (or lookback period) determined by a specified date and offset. |
| DatePart | Extracts the specified date part from a date value. |
| DateParse | Parses a text value in a specified format and returns a datetime value (date data type) in ISO format. |
| DateTrunc | Truncates the date to the specified date part. |
| Day | Returns the day of the month from a date value as a number. |
| DayOfYear | Returns the day of the year from a date value as a number. |
| EndOfMonth | Returns the last day of the month from a date value. |
| Hour | Returns the hour component from a date value as a number. |
| InDateRange | Determines if a date falls within a specified date range and returns True or False. |
| InPriorDateRange | Determines if a date falls within the date range of a prior period and returns True or False. |
| LastDay | Evaluates a specified component in a date value and returns the last datetime value of that component in ISO format. |
| MakeDate | Evaluates specified values representing year, month, and day units and returns a datetime value in ISO format. |
| Minute | Returns an integer representing the minute component in a specified datetime value. |
| Month | Returns an integer representing the month component in a specified datetime value. |
| MonthName | Returns the name of the month component from a specified datetime value. |
| Now | Returns the current date and time using your organization’s account timezone. |
| Quarter | Returns an integer representing the quarter component in a specified datetime value. |
| Second | Returns an integer representing the second component in a specified datetime value. |
| Today | Returns the current date using your organization’s account timezone. |
| Weekday | Returns an integer representing the day of the week in a specified datetime value. |
| WeekdayName | Returns the name of the day of the week in a specified datetime value. |
| Year | Returns an integer representing the year component in a specified datetime value. |