Date functions

Date

Function 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 between 0 and 6 representing the day of the week from a DateTime 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 a DateTime value for the end of the day.
Date.EndOfMonth Returns a DateTime value for the end of the month.
Date.EndOfQuarter Returns a Date/DateTime/DateTimeZone value representing the end of the quarter. The date and time portions are reset to their terminating values for the quarter. The timezone information is persisted.
Date.EndOfWeek Returns a DateTime value for the end of the week.
Date.EndOfYear Returns a DateTime value for the end of the year.
Date.From Returns a date value from a value.
Date.FromText Returns a Date value from a set of date formats and culture value.
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 a DateTime value for the start of the day.
Date.StartOfMonth Returns a DateTime value representing the start of the month.
Date.StartOfQuarter Returns a DateTime value representing the start of the quarter.
Date.StartOfWeek Returns a DateTime value representing the start of the week.
Date.StartOfYear Returns a DateTime value representing 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.
Parameter values Description
Day.Sunday Represents Sunday.
Day.Monday Represents Monday.
Day.Tuesday Represents Tuesday.
Day.Wednesday Represents Wednesday.
Day.Thursday Represents Thursday.
Day.Friday Represents Friday.
Day.Saturday Represents Saturday.