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.

Was this page helpful?
Yes No