Date Functions

Function Description
AdjustMonth Returns the date that is a number of months after the given date, with the same day number.
AdjustYear Returns the date that is a number of years after the given date, with the same month and day.
Date Creates a date from a given year, month, and day.
Day Returns the day of the month of the given date.
DayOfWeek Returns the number of days by which the given date follows the first day of the week (Sunday returns 0).
DayOfYear Returns the number of days by which the given date follows the first day of the year.
FirstDayOfMonth Returns the first day of the month in which the date falls.
FirstDayOfQuarter Returns the first day of the quarter in which the date falls.
FirstDayOfPeriod Returns the first day of the period in which the given date falls.
FirstDayOfWeek Returns the date corresponding to the first day of the week containing the given date.
FirstDayOfYear Returns the first day of the year in which the date falls.
IsLeapDay Returns true if the date is February 29.
IsLeapYear Returns true if the date falls in a leap year.
ISOWeek Calculates an ISO week number for the given date.
LastDayOfMonth Returns the last day of the month in which the date falls.
LastDayOfQuarter Returns the last day of quarter in which the date falls.
LastDayOfPeriod Returns the last day of the period in which the given date falls.
LastDayOfWeek Returns the date corresponding to the last day of the week containing the given date.
LastDayOfYear Returns the last day of the year in which the date falls.
Month Returns the numeric month of the given date.
MonthsBetween Returns the number of boundaries (beginning of month) crossed between the specified dates.
NextDayOfWeek Returns the date of the next specified weekday following the given date.
PrevDayOfWeek Returns the date of the previous specified weekday before the given date.
Quarter Returns the numeric quarter of the given date.
QuartersBetween Returns the number of boundaries (beginning of quarter) crossed between the specified dates.
Today Returns the current date in the local time zone.
Week Calculates the week number for a given date.
Workday Adds a specified number of workdays to a date.
Workdays Calculates a duration in work days between start and end dates inclusive.
Year Returns a year number of date.
YearsBetween Returns the number of boundaries (beginning of year) crossed between the specified dates.