Share via


Date functions

These functions create and manipulate the date component of date, datetime, and datetimezone values.

Name Description
Date.AddDays Returns a Date/DateTime/DateTimeZone value with the day portion incremented by the number of days provided. It also handles incrementing the month and year potions of the value as appropriate.
Date.AddMonths Returns a DateTime value with the month portion incremented by n months.
Date.AddQuarters Returns a Date/DateTime/DateTimeZone value incremented by the number of quarters provided. Each quarter is defined as a duration of three months. It also handles incrementing the year potion of the value as appropriate.
Date.AddWeeks Returns a Date/DateTime/DateTimeZone value incremented by the number of weeks provided. Each week is defined as a duration of seven days. It also handles incrementing the month and year potions of the value as appropriate.
Date.AddYears Returns a DateTime value with the year portion incremented by n years.
Date.Day Returns the day for a DateTime value.
Date.DayOfWeek Returns a number (from 0 to 6) indicating the day of the week of the provided value.
Date.DayOfWeekName Returns the day of the week name.
Date.DayOfYear Returns a number that represents the day of the year from a DateTime value.
Date.DaysInMonth Returns the number of days in the month from a DateTime value.
Date.EndOfDay Returns the end of the day.
Date.EndOfMonth Returns the end of the month.
Date.EndOfQuarter Returns the end of the quarter.
Date.EndOfWeek Returns the end of the week.
Date.EndOfYear Returns the end of the year.
Date.From Returns a date value from a value.
Date.FromText Creates a Date from local, universal, and custom Date formats.
Date.IsInCurrentDay Indicates whether the given datetime value dateTime occurs during the current day, as determined by the current date and time on the system.
Date.IsInCurrentMonth Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current month, as determined by the current date and time on the system.
Date.IsInCurrentQuarter Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current quarter, as determined by the current date and time on the system.
Date.IsInCurrentWeek Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current week, as determined by the current date and time on the system.
Date.IsInCurrentYear Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current year, as determined by the current date and time on the system.
Date.IsInNextDay Indicates whether the given datetime value dateTime occurs during the next day, as determined by the current date and time on the system.
Date.IsInNextMonth Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next month, as determined by the current date and time on the system.
Date.IsInNextNDays Indicates whether the given datetime value dateTime occurs during the next number of days, as determined by the current date and time on the system.
Date.IsInNextNMonths Indicates whether the given datetime value dateTime occurs during the next number of months, as determined by the current date and time on the system.
Date.IsInNextNQuarters Indicates whether the given datetime value dateTime occurs during the next number of quarters, as determined by the current date and time on the system.
Date.IsInNextNWeeks Indicates whether the given datetime value dateTime occurs during the next number of weeks, as determined by the current date and time on the system.
Date.IsInNextNYears Indicates whether the given datetime value dateTime occurs during the next number of years, as determined by the current date and time on the system.
Date.IsInNextQuarter Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next quarter, as determined by the current date and time on the system.
Date.IsInNextWeek Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next week, as determined by the current date and time on the system.
Date.IsInNextYear Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next year, as determined by the current date and time on the system.
Date.IsInPreviousDay Indicates whether the given datetime value dateTime occurs during the previous day, as determined by the current date and time on the system.
Date.IsInPreviousMonth Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous month, as determined by the current date and time on the system.
Date.IsInPreviousNDays Indicates whether the given datetime value dateTime occurs during the previous number of days, as determined by the current date and time on the system.
Date.IsInPreviousNMonths Indicates whether the given datetime value dateTime occurs during the previous number of months, as determined by the current date and time on the system.
Date.IsInPreviousNQuarters Indicates whether the given datetime value dateTime occurs during the previous number of quarters, as determined by the current date and time on the system.
Date.IsInPreviousNWeeks Indicates whether the given datetime value dateTime occurs during the previous number of weeks, as determined by the current date and time on the system.
Date.IsInPreviousNYears Indicates whether the given datetime value dateTime occurs during the previous number of years, as determined by the current date and time on the system.
Date.IsInPreviousQuarter Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous quarter, as determined by the current date and time on the system.
Date.IsInPreviousWeek Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous week, as determined by the current date and time on the system.
Date.IsInPreviousYear Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous year, as determined by the current date and time on the system.
Date.IsInYearToDate Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred in the period starting January 1st of the current year and ending on the current day, as determined by the current date and time on the system.
Date.IsLeapYear Returns a logical value indicating whether the year portion of a DateTime value is a leap year.
Date.Month Returns the month from a DateTime value.
Date.MonthName Returns the name of the month component.
Date.QuarterOfYear Returns a number between 1 and 4 for the quarter of the year from a DateTime value.
Date.StartOfDay Returns the start of the day.
Date.StartOfMonth Returns the start of the month.
Date.StartOfQuarter Returns the start of the quarter.
Date.StartOfWeek Returns the start of the week.
Date.StartOfYear Returns the start of the year.
Date.ToRecord Returns a record containing parts of a Date value.
Date.ToText Returns a text value from a Date value.
Date.WeekOfMonth Returns a number for the count of week in the current month.
Date.WeekOfYear Returns a number for the count of week in the current year.
Date.Year Returns the year from a DateTime value.
#date Creates a date value from year, month, and day.