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. |