Date Functions

Functions for creating, manipulating, and extracting parts of date values.

Date.AddDays
Adds a specified number of days to a date value.
Date.AddMonths
Adds a specified number of months to a date value.
Date.AddQuarters
Adds a specified number of quarters to a date value.
Date.AddWeeks
Adds a specified number of weeks to a date value.
Date.AddYears
Adds a specified number of years to a date value.
Date.Day
Returns the day of the month from a date value.
Date.DayOfWeek
Returns the day of the week for a given date.
Date.DayOfWeekName
Returns the name of the day of the week for the given date.
Date.DayOfYear
Returns the day of the year (1–366) for the given date.
Date.DaysInMonth
Returns the number of days in the month of the given date.
Date.EndOfDay
Returns the last moment of the day for the given date or datetime value.
Date.EndOfMonth
Returns the last day of the month for a given date.
Date.EndOfQuarter
Returns the last moment of the quarter containing the given date.
Date.EndOfWeek
Returns the last day of the week containing the given date.
Date.EndOfYear
Returns the last day of the year for a given date.
Date.From
Converts a value to a date.
Date.FromText
Converts a text representation of a date to a date value.
Date.IsInCurrentDay
Returns true if the date is today (local time).
Date.IsInCurrentMonth
Returns true if the date falls within the current calendar month.
Date.IsInCurrentQuarter
Returns true if the date falls within the current calendar quarter.
Date.IsInCurrentWeek
Returns true if the date falls within the current calendar week.
Date.IsInCurrentYear
Returns true if the date falls within the current calendar year.
Date.IsInNextDay
Returns true if the date is tomorrow relative to today.
Date.IsInNextMonth
Returns true if the date falls in the next calendar month.
Date.IsInNextNDays
Returns true if the date falls within the next N days (not including today).
Date.IsInNextNMonths
Returns true if the date falls within the next N calendar months.
Date.IsInNextNQuarters
Returns true if the date falls within the next N calendar quarters.
Date.IsInNextNWeeks
Returns true if the date falls within the next N calendar weeks.
Date.IsInNextNYears
Returns true if the date falls within the next N calendar years.
Date.IsInNextQuarter
Returns true if the date falls in the next calendar quarter.
Date.IsInNextWeek
Returns true if the date falls in the next calendar week.
Date.IsInNextYear
Returns true if the date falls in the next calendar year.
Date.IsInPreviousDay
Returns true if the date was yesterday.
Date.IsInPreviousMonth
Returns true if the date falls in the previous calendar month.
Date.IsInPreviousNDays
Returns true if the date falls within the previous N days (not including today).
Date.IsInPreviousNMonths
Returns true if the date falls within the previous N calendar months.
Date.IsInPreviousNQuarters
Returns true if the date falls within the previous N calendar quarters.
Date.IsInPreviousNWeeks
Returns true if the date falls within the previous N calendar weeks.
Date.IsInPreviousNYears
Returns true if the date falls within the previous N calendar years.
Date.IsInPreviousQuarter
Returns true if the date falls in the previous calendar quarter.
Date.IsInPreviousWeek
Returns true if the date falls in the previous calendar week.
Date.IsInPreviousYear
Returns true if the date falls in the previous calendar year.
Date.IsInYearToDate
Returns true if the date falls between January 1 of the current year and today (inclusive).
Date.IsLeapYear
Returns true if the year of the given date is a leap year.
Date.Month
Returns the month from a date value.
Date.MonthName
Returns the name of the month for the given date.
Date.QuarterOfYear
Returns the quarter of the year (1–4) for the given date.
Date.StartOfDay
Returns the first moment of the day (midnight) for the given date or datetime value.
Date.StartOfMonth
Returns the first day of the month for a given date.
Date.StartOfQuarter
Returns the first day of the quarter containing the given date.
Date.StartOfWeek
Returns the first day of the week containing the given date.
Date.StartOfYear
Returns the first day of the year for a given date.
Date.ToRecord
Returns a record containing the Year, Month, and Day fields of a date value.
Date.ToText
Converts a date value to a text string.
Date.WeekOfMonth
Returns the week number within the month (1–6) for the given date.
Date.WeekOfYear
Returns the week number within the year (1–54) for the given date.
Date.Year
Returns the year from a date value.
#date
Creates a date value from year, month, and day components.