Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |