> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://help.sigmacomputing.com/docs/date-functions/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server. # Date functions > Browse Sigma date functions to analyze, convert, and manipulate date and time values in formulas. Date functions evaluate, convert, and manipulate date and time values. | Function | Description | | :----------------------------------------- | :-------------------------------------------------------------------------------------------------------------------------- | | [BusinessDays](/docs/businessdays) | Counts the weekdays between two dates, excluding Saturdays and Sundays. | | [ConvertTimezone](/docs/converttimezone) | Converts date and time values to the specified time zone. | | [DateAdd](/docs/dateadd) | Adds a specified quantity of time to a date. | | [DateDiff](/docs/datediff) | Calculates the time difference between two dates. | | [DateFormat](/docs/dateformat) | Formats a date value to text based on the format provided. | | [DateFromUnix](datefromunix) | Converts a Unix timestamp to a date value. | | [DateFromUnixMs](/docs/datefromunixms) | Converts a Unix timestamp in milliseconds to a date value. | | [DateFromUnixUs](/docs/datefromunixus) | Converts a Unix timestamp in microseconds to a date value. | | [DateLookback](/docs/datelookback) | Returns the value of a variable at a previous point in time (or lookback period) determined by a specified date and offset. | | [DatePart](/docs/datepart) | Extracts the specified date part from a date value. | | [DateParse](/docs/dateparse) | Parses a text value in a specified format and returns a datetime value (date data type) in ISO format. | | [DateTrunc](/docs/datetrunc) | Truncates the date to the specified date part. | | [Day](/docs/day) | Returns the day of the month from a date value as a number. | | [DayOfYear](/docs/dayofyear) | Returns the day of the year from a date value as a number. | | [EndOfMonth](/docs/endofmonth) | Returns the last day of the month from a date value. | | [Hour](/docs/hour) | Returns the hour component from a date value as a number. | | [InDateRange](/docs/indaterange) | Determines if a date falls within a specified date range and returns `True` or `False`. | | [InPriorDateRange](/docs/inpriordaterange) | Determines if a date falls within the date range of a prior period and returns `True` or `False`. | | [LastDay](/docs/lastday) | Evaluates a specified component in a date value and returns the last datetime value of that component in ISO format. | | [MakeDate](/docs/makedate) | Evaluates specified values representing year, month, and day units and returns a datetime value in ISO format. | | [Minute](/docs/minute) | Returns an integer representing the minute component in a specified datetime value. | | [Month](/docs/month) | Returns an integer representing the month component in a specified datetime value. | | [MonthName](/docs/monthname) | Returns the name of the month component from a specified datetime value. | | [Now](/docs/now) | Returns the current date and time using your organization's account timezone. | | [Quarter](/docs/quarter) | Returns an integer representing the quarter component in a specified datetime value. | | [Second](/docs/second) | Returns an integer representing the second component in a specified datetime value. | | [Today](/docs/today) | Returns the current date using your organization's account timezone. | | [Weekday](/docs/weekday) | Returns an integer representing the day of the week in a specified datetime value. | | [WeekdayName](/docs/weekdayname) | Returns the name of the day of the week in a specified datetime value. | | [Year](/docs/year) | Returns an integer representing the year component in a specified datetime value. | > Official documentation and guidance for using Sigma to build AI apps, dashboards, and agents on governed warehouse data. ## Docs - [BusinessDays](https://help.sigmacomputing.com/docs/businessdays.md): Use the Sigma BusinessDays function to count the weekdays between two dates, excluding Saturdays and Sundays. - [ConvertTimezone](https://help.sigmacomputing.com/docs/converttimezone.md): Use the Sigma ConvertTimezone function to convert datetime values to the specified time zone. - [DateAdd](https://help.sigmacomputing.com/docs/dateadd.md): Use the Sigma DateAdd function to add or subtracts a specified amount of time from a date. - [DateDiff](https://help.sigmacomputing.com/docs/datediff.md): Use the Sigma DateDiff function to calculate the time difference between two dates. - [DateFormat](https://help.sigmacomputing.com/docs/dateformat.md): Use the Sigma DateFormat function to evaluate a date value and extract datetime components (as text strings) in the specified format. - [DateFromUnix](https://help.sigmacomputing.com/docs/datefromunix.md): Use the Sigma DateFromUnix function to convert a Unix timestamp to the date data type in ISO date time format. - [DateFromUnixMs](https://help.sigmacomputing.com/docs/datefromunixms.md): Use the Sigma DateFromUnixMs function to convert a Unix timestamp in milliseconds to the date data type in ISO date time format. - [DateFromUnixUs](https://help.sigmacomputing.com/docs/datefromunixus.md): Use the Sigma DateFromUnixUs function to convert a Unix timestamp in microseconds to the date data type in ISO date time format. - [DateLookback](https://help.sigmacomputing.com/docs/datelookback.md): Use the Sigma DateLookback function to return the value of a variable at a previous point in time (or lookback period) determined by a specified. - [DatePart](https://help.sigmacomputing.com/docs/datepart.md): Use the Sigma DatePart function to extract a specified part of a date from a date value. - [DateParse](https://help.sigmacomputing.com/docs/dateparse.md): Use the Sigma DateParse function to parse a text string representing a date in the specified format and return the equivalent ISO datetime value. - [DateTrunc](https://help.sigmacomputing.com/docs/datetrunc.md): Truncates the date to the specified date part. - [Day](https://help.sigmacomputing.com/docs/day.md): Returns the day of the month of a date value as a number. - [DayOfYear](https://help.sigmacomputing.com/docs/dayofyear.md): Converts a date to the number day of the year, from 1 (Jan 1) to 365 (Dec 31). - [EndOfMonth](https://help.sigmacomputing.com/docs/endofmonth.md): Returns the last day of the month of a Date value. - [Hour](https://help.sigmacomputing.com/docs/hour.md): Returns the hour component of the given Date as a number. - [InDateRange](https://help.sigmacomputing.com/docs/indaterange.md): Use the Sigma InDateRange function to determine if an inputted date is within a specified range of dates, returning True or False. - [InPriorDateRange](https://help.sigmacomputing.com/docs/inpriordaterange.md): Use the Sigma InPriorDateRange function to determine if an inputted date is within a specified date range in a previous time period, returning True. - [LastDay](https://help.sigmacomputing.com/docs/lastday.md): Use the Sigma LastDay function to evaluate a specified date component (i.e., year, quarter, month, or week) in a date value and return the last. - [MakeDate](https://help.sigmacomputing.com/docs/makedate.md): Use the Sigma MakeDate function to evaluate specified values representing individual date (year, month, day) and time (hour, minute, second). - [Minute](https://help.sigmacomputing.com/docs/minute.md): Use the Sigma Minute function to return an integer representing the minute component of a specified date and time. - [Month](https://help.sigmacomputing.com/docs/month.md): Use the Sigma Month function to return an integer representing the month component of a specified date and time. - [MonthName](https://help.sigmacomputing.com/docs/monthname.md): Use the Sigma MonthName function to return the name of the month component from a specified datetime value. - [Now](https://help.sigmacomputing.com/docs/now.md): Use the Sigma Now function to return the current date and time and present it in your Account Time Zone. - [Quarter](https://help.sigmacomputing.com/docs/quarter.md): Use the Sigma Quarter function to return an integer representing the quarter in which a specified date and time occurs. - [Second](https://help.sigmacomputing.com/docs/second.md): Use the Sigma Second function to return an integer representing the second component of a specified date and time. - [Today](https://help.sigmacomputing.com/docs/today.md): Use the Sigma Today function to return the current date in ISO format and present it in your Account Time Zone. - [Weekday](https://help.sigmacomputing.com/docs/weekday.md): Use the Sigma Weekday function to evaluate a specified date and return an integer representing the day of the week (with 1 representing Sunday, 2. - [WeekdayName](https://help.sigmacomputing.com/docs/weekdayname.md): Use the Sigma WeekdayName function to evaluate a specified date and return the day of the week by name (Sunday, Monday, Tuesday, etc.). - [Year](https://help.sigmacomputing.com/docs/year.md): Use the Sigma Year function to return an integer representing the year component of a specified date and time.