Date Functions

Perform date parsing and math operations.

Date Function	Description
AddDays	The AddDays function adds a specified number of days to a DateTime value.
AddHours	The AddHours function adds a specified number of hours to a DateTime value.
AddMilliseconds	The AddMilliseconds function adds a specified number of milliseconds to a DateTime value.
AddMinutes	The AddMinutes function adds a specified number of minutes to a DateTime value.
AddMonths	The AddMonths function adds a specified number of months to a DateTime value.
AddSeconds	The AddSeconds function adds a specified number of seconds to a DateTime value.
AddWeekdays	The AddWeekdays function adds a specified number of weekdays to a DateTime value.
AddYears	The AddYears function adds a specified number of years to a DateTime value.
BuildDate	The BuildDate function returns a date from a specified year, month, and day.
Day	Returns the day of the month for a given Date or DateTime.
DayDiff	The DayDiff function returns the number of days between two Date values.
DayOfWeek	Returns the day of the week with 0 = Sunday and 6 = Saturday.
DayOfYear	Returns the day of the year, 1 = 1/1 and 365(366) = 12/31.
DaysInMonth	The DaysInMonth function returns the number of days in the month.
DaysInYear	Returns the number of days in the year.
GetLocalDateTime	Returns a datetime value having Local kind.
GetUnspecifiedDateTime	Returns a datetime value having an Unspecified kind.
GetUtcDateTime	Returns a datetime value having UTC kind.
Hour	The Hour function returns the hour of the day for a given DateTime (0 to 23).
HourDiff	The HourDiff function returns the number of hours between two DateTime values.
IsDate	The IsDate function determines if an expression is a valid Date (or a DateTime with a zero time offset).
IsDateTime	The IsDateTime function determines if an expression is a valid DateTime.
IsLeapYear	The IsLeapYear function returns true if the year is a leap year.
IsLocalDateTime	Returns true if the expression is a valid Local kind datetime.
IsUnspecifiedDateTime	Returns true if the expression is a valid unspecified kind datetime.
IsUtcDateTime	Returns true if the expression is a valid UTC kind datetime.
IsWeekday	The IsWeekday function returns true if a given DateTime is not a Saturday or Sunday.
IsWeekend	Returns true if the given date is a Saturday or Sunday.
Millisecond	The Millisecond function returns the milliseconds for a given DateTime (0 to 999).
MillisecondDiff	The MillisecondDiff function returns the number of milliseconds between two DateTime values.
Minute	The Minute function returns the minute of the hour for a given DateTime (0 to 59).
MinuteDiff	The MinuteDiff function returns the number of minutes between two DateTime values.
Month	Returns the month for a given Date or DateTime.
MonthDiff	The MonthDiff function returns the number of months between two Date values.
Now	The Now function returns the current date and time in the local time zone, as of the start of rule processing.
Second	The Second function returns the seconds for a given DateTime (0 to 59).
SecondDiff	The SecondDiff function returns the number of seconds between two DateTime values.
ToDate	The ToDate function converts an expression to a Date value.
ToDateTime	The ToDateTime function converts an expression to a DateTime value.
Today	Returns the current date as of the start of rule processing.
ToTime	The ToTime function returns a time based on source parameters. The date portion is 1/2/0001.
WeekdayDiff	The WeekdayDiff function returns the number of weekdays between two Date values.
Year	Returns the year for a given Date or DateTime.
YearDiff	The YearDiff function returns the number of years between two Date values.