Date Functions

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.