Name 

Description 

Functions 

The following table lists functions in this documentation. 

Variables 

The following table lists variables in this documentation. 

Constants 

The following table lists constants in this documentation. 

Name 

Description 

DayFriday 

DayFriday is a constant that indicates Friday. 

DayMonday 

DayMonday is a constant that indicates Monday. 

DaySaturday 

DaySaturday is a constant that indicates Saturday. 

DaysPerWeek 

DaysPerWeek represents the number of days in a week. 

DaysPerYear 

DaysPerYear represents the number of days in a year. 

DaySunday 

DaySunday is a constant that indicates Sunday. 

DayThursday 

DayThursday is a constant that indicates Thursday. 

DayTuesday 

DayTuesday is a constant that indicates Tuesday. 

DayWednesday 

DayWednesday is a constant that indicates Wednesday. 

MonthsPerYear 

MonthsPerYear represents the number of months in a year. 

OneHour 

OneHour represents the inverse value of the HoursPerDay constant. 

OneMillisecond 

OneMillisecond represents the inverse value of the MSecsPerDay constant. 

OneMinute 

OneMinute represents the inverse value of the MinsPerDay constant. 

OneSecond 

OneSecond represents the inverse value of the SecsPerDay constant. 

RecodeLeaveFieldAsIs 

RecodeLeaveFieldAsIs is a constant used for the TDateTime fields that you want to leave unchanged. 

WeeksPerFortnight 

WeeksPerFortnight represents the number of weeks in a fortnight. 

YearsPerCentury 

YearsPerCentury represents the number of years in a century. 

YearsPerDecade 

YearsPerDecade represents the number of years in a decade. 

YearsPerMillennium 

YearsPerMillennium represents the number of years in a millennium. 

 

Name 

Description 

 

CompareDate 

Indicates the relationship between the date portions of two TDateTime values. 

 

CompareDateTime 

Indicates the relationship between two TDateTime values. 

 

CompareTime 

Indicates the relationship between the time portions of two TDateTime values. 

 

DateOf 

Strips the time portion from a TDateTime value. 

 

DateTimeToJulianDate 

Converts a TDateTime value into a Julian date. 

 

DateTimeToModifiedJulianDate 

Converts a TDateTime value into a modified Julian date. 

 

DateTimeToUnix 

Converts a TDateTime value into a Unix/Linux-style date-and-time value. 

 

DayOf 

Returns the day of the month represented by a TDateTime value. 

 

DayOfTheMonth 

Returns the day of the month represented by a TDateTime value. 

 

DayOfTheWeek 

Returns the day of the week represented by a TDateTime value. 

 

DayOfTheYear 

Returns the number of days between a specified TDateTime value and December 31 of the previous year. 

 

DaysBetween 

Returns the number of whole days between two specified TDateTime values. 

 

DaysInAMonth 

Returns the number of days in a specified month of a specified year. 

 

DaysInAYear 

Returns the number of days in a specified year. 

 

DaysInMonth 

Returns the number of days in the month of a specified TDateTime value. 

 

DaysInYear 

Returns the number of days in the year of a specified TDateTime value. 

 

DaySpan 

Returns the number of days (including fractional days) between two specified TDateTime values. 

 

DecodeDateDay 

Returns the year and day of the year for a specified TDateTime. 

 

DecodeDateMonthWeek 

Returns the year, month, week of the month, and day of the week for a specified TDateTime. 

 

DecodeDateTime 

Returns Year, Month, Day, Hour, Minute, Second, and Millisecond values for a TDateTime. 

 

DecodeDateWeek 

Returns the year, week of the year, and day of the week for a specified TDateTime value object. 

 

DecodeDayOfWeekInMonth 

For a given TDateTime value, returns the year, month, day of the week, and the count of that day of the week in the month. 

 

EncodeDateDay 

Returns a TDateTime that represents a specified day of the year for a specified year. 

 

EncodeDateMonthWeek 

Returns a TDateTime that represents a specified day of a specified week in a specified month and year. 

 

EncodeDateTime 

Returns a TDateTime that represents a specified year, month, day, hour, minute, second, and millisecond. 

 

EncodeDateWeek 

Returns a TDateTime that represents a specified day of a specified week in a specified year. 

 

EncodeDayOfWeekInMonth 

Returns a TDateTime that represents a specified occurrence of a day of the week within a specified month and year. 

 

EndOfADay 

Returns a TDateTime that represents the last millisecond of a specified day. 

 

EndOfADay 

Returns a TDateTime that represents the last millisecond of a specified day. 

 

EndOfAMonth 

Returns a TDateTime that represents the last millisecond of the last day of a specified month. 

 

EndOfAWeek 

Returns a TDateTime object value that represents the last millisecond of a specified day of a specified week. 

 

EndOfAYear 

Returns a TDateTime that represents the last millisecond of a specified year. 

 

EndOfTheDay 

Returns a TDateTime that represents the last millisecond of the day identified by a specified TDateTime. 

 

EndOfTheMonth 

Returns a TDateTime that represents the last millisecond of the last day of the month identified by a specified TDateTime. 

 

EndOfTheWeek 

Returns a TDateTime that represents the last millisecond of the last day of the week identified by a specified TDateTime. 

 

EndOfTheYear 

Returns a TDateTime that represents the last millisecond of the last day of the year identified by a specified TDateTime. 

 

HourOf 

Returns the hour of the day represented by a TDateTime value. 

 

HourOfTheDay 

Returns the hour of the day represented by a TDateTime value. 

 

HourOfTheMonth 

Returns the number of hours between a specified TDateTime value and 12:00 AM of the first day of the month. 

 

HourOfTheWeek 

Returns the number of hours between a specified TDateTime value and 12:00 AM of the first day of the week. 

 

HourOfTheYear 

Returns the number of hours between a specified TDateTime value and 12:00 AM of the first day of the year. 

 

HoursBetween 

Returns the number of whole hours between two specified TDateTime values. 

 

HourSpan 

Returns the number of Hours (including fractional Hours) between two specified TDateTime values. 

 

IncDay 

Returns a date shifted by a specified number of days. 

 

IncHour 

Returns a date/time value shifted by a specified number of hours. 

 

IncMilliSecond 

Returns a date/time value shifted by a specified number of milliseconds. 

 

IncMinute 

Returns a date/time value shifted by a specified number of minutes. 

 

IncSecond 

Returns a date/time value shifted by a specified number of seconds. 

 

IncWeek 

Returns a date shifted by a specified number of weeks. 

 

IncYear 

Returns a date shifted by a specified number of years. 

 

InvalidDateDayError 

InvalidDateDayError is used internally. 

 

InvalidDateMonthWeekError 

InvalidDateMonthWeekError is used internally. 

 

InvalidDateTimeError 

InvalidDateTimeError is used internally. 

 

InvalidDateWeekError 

InvalidDateWeekError is used internally. 

 

InvalidDayOfWeekInMonthError 

InvalidDayOfWeekInMonthError is used internally. 

 

IsInLeapYear 

Indicates whether a specified TDateTime value occurs in a leap year. 

 

IsPM 

Indicates whether the time portion of a specified TDateTime value occurs after noon. 

 

IsSameDay 

Indicates whether a specified TDateTime value occurs on a the same day as a criterion date. 

 

IsToday 

Indicates whether a specified TDateTime value occurs on the current date. 

 

IsValidDate 

Indicates whether a specified year, month, and day represent a valid date. 

 

IsValidDateDay 

Indicates whether a specified year and day of the year represent a valid date. 

 

IsValidDateMonthWeek 

Indicates whether a specified year, month, week of the month, and day of the week represent a valid date. 

 

IsValidDateTime 

Indicates whether a specified year, month, day, hour, minute, second, and millisecond represent a valid date and time. 

 

IsValidDateWeek 

Indicates whether a specified year, week of the year, and day of the week represent a valid date. 

 

IsValidTime 

Indicates whether a specified hour, minute, second, and millisecond represent a valid date and time. 

 

JulianDateToDateTime 

Converts a Julian date to a TDateTime value. 

 

MilliSecondOf 

Returns the millisecond of the second represented by a TDateTime value. 

 

MilliSecondOfTheDay 

Returns the number of milliseconds between a specified TDateTime value and the beginning of the same day. 

 

MilliSecondOfTheHour 

Returns the number of milliseconds between a specified TDateTime value and the beginning of the same hour. 

 

MilliSecondOfTheMinute 

Returns the number of milliseconds between a specified TDateTime value and the beginning of the same minute. 

 

MilliSecondOfTheMonth 

Returns the number of milliseconds between a specified TDateTime value and the beginning of the month. 

 

MilliSecondOfTheSecond 

Returns the millisecond of the second represented by a TDateTime value. 

 

MilliSecondOfTheWeek 

Returns the number of milliseconds between a specified TDateTime value and 12:00:00:00 AM of the first day of the week. 

 

MilliSecondOfTheYear 

Returns the number of milliseconds between a specified TDateTime value and 12:00:00:00 AM of the first day of the year. 

 

MilliSecondsBetween 

Returns the number of milliseconds between two specified TDateTime values. 

 

MilliSecondSpan 

Returns the number of milliseconds between two specified TDateTime values. 

 

MinuteOf 

Returns the minute of the hour represented by a TDateTime value. 

 

MinuteOfTheDay 

Returns the number of minutes between a specified TDateTime value and 12:00 AM of the same day. 

 

MinuteOfTheHour 

Returns the number of minutes between a specified TDateTime value and the beginning of the same hour. 

 

MinuteOfTheMonth 

Returns the number of minutes between a specified TDateTime value and 12:00 AM of the first day of the month. 

 

MinuteOfTheWeek 

Returns the number of minutes between a specified TDateTime value and 12:00 AM of the first day of the week. 

 

MinuteOfTheYear 

Returns the number of minutes between a specified TDateTime value and 12:00 AM of the first day of the year. 

 

MinutesBetween 

Returns the number of minutes between two specified TDateTime values. 

 

MinuteSpan 

Returns the number of minutes, including fractions thereof, between two specified TDateTime values. 

 

ModifiedJulianDateToDateTime 

Converts a modified Julian date to a TDateTime value. 

 

MonthOf 

Returns the month of the year represented by a TDateTime value. 

 

MonthOfTheYear 

Returns the month of the year represented by a TDateTime value. 

 

MonthsBetween 

Returns the approximate number of months between two specified TDateTime values. 

 

MonthSpan 

Returns the approximate number of months, including fractions, between two specified TDateTime values. 

 

NthDayOfWeek 

Returns which occurrence of its weekday a specified TDateTime value represents. 

 

RecodeDate 

Replaces the date portion of a specified TDateTime value. 

 

RecodeDateTime 

Selectively replaces parts of a specified TDateTime value. 

 

RecodeDay 

Replaces the day of the month for a specified TDateTime value. 

 

RecodeHour 

Replaces the hour of the day for a specified TDateTime value. 

 

RecodeMilliSecond 

Replaces the millisecond of the second for a specified TDateTime value. 

 

RecodeMinute 

Replaces the minute of the hour for a specified TDateTime value. 

 

RecodeMonth 

Replaces the month of the year for a specified TDateTime value. 

 

RecodeSecond 

Replaces the second of the minute for a specified TDateTime value. 

 

RecodeTime 

Replaces the time portion of a specified TDateTime value. 

 

RecodeYear 

Replaces the year for a specified TDateTime value. 

 

SameDate 

Indicates whether two TDateTime values represent the same year, month, and day. 

 

SameDateTime 

Indicates whether two TDateTime values represent the same year, month, day, hour, minute, second, and millisecond. 

 

SameTime 

Indicates whether two TDateTime values represent the same time of day, ignoring the date portion. 

 

SecondOf 

Returns the second of the minute represented by a TDateTime value. 

 

SecondOfTheDay 

Returns the number of seconds between a specified TDateTime value and 12:00:00 AM of the same day. 

 

SecondOfTheHour 

Returns the number of seconds between a specified TDateTime value and the beginning of the same hour. 

 

SecondOfTheMinute 

Returns the number of seconds between a specified TDateTime value and the beginning of the same minute. 

 

SecondOfTheMonth 

Returns the number of seconds between a specified TDateTime value and 12:00:00 AM on the first day of the month. 

 

SecondOfTheWeek 

Returns the number of seconds between a specified TDateTime value and 12:00:00 AM of the first day of the week. 

 

SecondOfTheYear 

Returns the number of seconds between a specified TDateTime value and 12:00:00 AM on the first day of the year. 

 

SecondsBetween 

Returns the number of seconds between two specified TDateTime values. 

 

SecondSpan 

Returns the number of seconds (including fractions thereof) between two specified TDateTime values. 

 

StartOfADay 

Returns a TDateTime that represents 12:00:00:00 AM on a specified day. 

 

StartOfADay 

Returns a TDateTime that represents 12:00:00:00 AM on a specified day. 

 

StartOfAMonth 

Returns a TDateTime that represents 12:00:00:00 AM on the first day of a specified month. 

 

StartOfAWeek 

Returns a TDateTime that represents 1the first moment on a specified day of a specified week. 

 

StartOfAYear 

Returns a TDateTime that represents the first moment on the first day of a specified year. 

 

StartOfTheDay 

Returns a TDateTime that represents 12:00:00:00 AM on the day identified by a specified TDateTime. 

 

StartOfTheMonth 

Returns a TDateTime that represents 12:00:00:00 AM on the first day of the month identified by a specified TDateTime. 

 

StartOfTheWeek 

Returns a TDateTime that represents 12:00:00:00 AM on the first day of the week identified by a specified TDateTime. 

 

StartOfTheYear 

Returns a TDateTime that represents 12:00:00:00 AM on the first day of the year identified by a specified TDateTime. 

 

TimeOf 

Strips the date portion from a TDateTime value. 

 

Today 

Returns a TDateTime value that represents the current date. 

 

Tomorrow 

Returns a TDateTime value that represents the following day. 

 

TryEncodeDateDay 

Calculates the TDateTime value that represents a specified day of the year for a specified year. 

 

TryEncodeDateMonthWeek 

Calculates the TDateTime value that represents a specified day of a specified week in a specified month and year. 

 

TryEncodeDateTime 

Calculates the TDateTime value that represents a specified year, month, day, hour, minute, second, and millisecond. 

 

TryEncodeDateWeek 

Calculates the TDateTime value that represents a specified day of a specified week in a specified year. 

 

TryEncodeDayOfWeekInMonth 

Calculates a TDateTime that represents a specified occurrence of a day of the week within a specified month and year. 

 

TryJulianDateToDateTime 

Converts a Julian date to a TDateTime value. 

 

TryModifiedJulianDateToDateTime 

Converts a modified Julian date to a TDateTime value. 

 

TryRecodeDateTime 

Selectively replaces parts of a specified TDateTime value. 

 

UnixToDateTime 

Converts a Unix/Linux style date-and-time value to a TDateTime value. 

 

WeekOf 

Returns the week of the year represented by a TDateTime value. 

 

WeekOfTheMonth 

Returns the week of the month represented by a TDateTime value. 

 

WeekOfTheMonth 

Returns the week of the month represented by a TDateTime value. 

 

WeekOfTheYear 

Returns the week of the year represented by a TDateTime value. 

 

WeekOfTheYear 

Returns the week of the year represented by a TDateTime value. 

 

WeeksBetween 

Returns the number of whole weeks between two specified TDateTime values. 

 

WeeksInAYear 

Returns the number of weeks in a specified year. 

 

WeeksInYear 

Returns the number of weeks in the year of a specified TDateTime value. 

 

WeekSpan 

Returns the number of weeks (including fractional weeks) between two specified TDateTime values. 

 

WithinPastDays 

Indicates whether two dates are within a specified number of days of each other. 

 

WithinPastHours 

Indicates whether two date/time values are within a specified number of hours of each other. 

 

WithinPastMilliSeconds 

Indicates whether two date/time values are within a specified number of milliseconds of each other. 

 

WithinPastMinutes 

Indicates whether two date/time values are within a specified number of minutes of each other. 

 

WithinPastMonths 

Indicates whether two date/time values are within a specified number of months of each other. 

 

WithinPastSeconds 

Indicates whether two date/time values are within a specified number of seconds of each other. 

 

WithinPastWeeks 

Indicates whether two date/time values are within a specified number of weeks of each other. 

 

WithinPastYears 

Indicates whether two date/time values are within a specified number of years of each other. 

 

YearOf 

Returns the year represented by a TDateTime value. 

 

YearsBetween 

Returns the approximate number of years between two specified TDateTime values. 

 

YearSpan 

Returns the approximate number of years (including fractions thereof) between two specified TDateTime values. 

 

Yesterday 

Returns a TDateTime value that represents the preceding day. 

Name 

Description 

ApproxDaysPerMonth 

ApproxDaysPerMonth represents the approximate number of days in a month, over a normal 4 year period. 

ApproxDaysPerYear 

ApproxDaysPerYear represents the approximate number of days in a year, over a normal 4 year period.