Date functions overview
Use date functions to analyze date input or extract individual time components (e.g., year, month, day, minute) from date objects.
For solutions to common date-based challenges, see Common Date Functions and Use Cases in Sigma QuickStarts.
- ConvertTimezone
- Converts date and time values to a specified time zone.
- Date
- Converts text and number values to ISO date time format.
- DateAdd
- Adds a specified quantity of time to a date.
- DateDiff
- Calculates the time difference between two dates.
- DateFormat
- Displays a date value in a specified format.
- DateFromUnix
- Converts a Unix timestamp to a date format.
- DatePart
- Extracts the specified date part from a date.
- DateParse
- Parses text values from a specified format into ISO date time format.
- DateTime
- Converts either a text or a date value into an ISO date time format.
- DateTrunc
- Truncates the date to the specified date part.
- Day
- Returns the day of the month from a date, as a number.
- EndOfMonth
- Returns the last day of the month from a date, as a number.
- Hour
- Returns the hour from a date, as a number.
- InDateRange
- Determines if a date is within a specified range of dates.
- InPriorDateRane
- Determines if a date is within a specified range of dates in a previous time period.
- LastDay
- Returns the last day of the specified part of a date, as a number.
- MakeDate
- Constructs the ISO date time from specified date part components.
- Minute
- Returns the minute part of a date, as an integer.
- Month
- Returns the month part of a date, as an integer.
- MonthName
- Returns the month part of a date, as the name of the month (a string).
- Now
- Returns the current date and time, using the organization's timezone.
- Quarter
- Returns the quarter part of a date, as an integer.
- Second
- Returns the second part of a date, as an integer.
- Today
- Returns the current date, using the organization's timezone.
- Weekday
- Returns the weekday part of a date, as an integer.
- WeekdayName
- Returns the weekday part of a date, as the name of the weekday (a string).
- Year
- Returns the year part of a date, as an integer.