Date & Time
|
Name |
Description |
|
AddDays |
Returns a DateTime that is the specified number of days away from the specified DateTime. |
|
AddHours |
Returns a DateTime that is the specified number of hours away from the specified DateTime. |
|
AddMilliseconds |
Returns a DateTime that is the specified number of milliseconds away from the specified DateTime. |
|
AddMinutes |
Returns a DateTime that is the specified number of minutes away from the specified DateTime. |
|
AddMonths |
Returns a DateTime that is the specified number of months away from the specified DateTime. |
|
AddSeconds |
Returns a DateTime that is the specified number of seconds away from the specified DateTime. |
|
AddWeeks |
Returns a DateTime that is the specified number of weeks away from the specified DateTime. |
|
AddYears |
Returns a DateTime that is the specified number of years away from the specified DateTime. |
|
DateAdd |
Returns a value containing a date and time value to which a specified time interval has been added. |
|
DateAdd |
Returns a value containing a date and time value to which a specified time interval has been added. |
|
DateDiff |
Returns a integer value specifying the number of time intervals between two Date values. |
|
DateDiff |
Returns a integer value specifying the number of time intervals between two Date values. |
|
DatePart |
Returns an integer value containing the specified component of a given Date value. |
|
DatePart |
Returns an integer value containing the specified component of a given Date value. |
|
DateSerial |
Returns a Date value representing a specified year, month, and day, with the time information set to midnight (00:00:00). |
|
DateString |
Returns or sets a string value representing the current date according to your system. |
|
DateValue |
Returns a Date value containing the date information represented by a string, with the time information set to midnight (00:00:00). |
|
Day |
Returns an integer value from 1 through 31 representing the day of the month. |
|
GetDayOfMonth |
Returns the day of the month that includes the date in the specified DateTime value. |
|
GetDayOfWeek |
Returns the day of the week that includes the date in the specified DateTime value. |
|
GetDayOfYear |
Returns the day of the year that includes the date in the specified DateTime value. |
|
GetDaysInMonth |
Returns the number of days in the specified month and year of the current era. |
|
GetDaysInYear |
Returns the number of days in the specified year of the current era. |
|
GetEra |
Returns the era of the specified DateTime. |
|
GetHour |
Returns the hours value in the specified DateTime. |
|
GetMilliseconds |
Returns the milliseconds value in the specified DateTime. |
|
GetMinute |
Returns the minutes value in the specified DateTime. |
|
GetMonth |
Returns the months value in the specified DateTime. |
|
GetMonthsInYear |
Returns the number of months in the specified year in the current era. |
|
GetSecond |
Returns the seconds value in the specified DateTime. |
|
GetWeekOfYear |
Returns the week of the year that includes the date in the specified DateTime value. |
|
GetYear |
Returns the years value in the specified DateTime. |
|
Hour |
Returns an integer value from 0 through 23 representing the hour of the day. |
|
IsLeapYear |
Determines whether the specified year in the current era is a leap year. |
|
Minute |
Returns an integer value from 0 through 59 representing the minute of the hour. |
|
Month |
Returns an integer value from 1 through 12 representing the month of the year. |
|
MonthName |
Returns a string value containing the name of the specified month. Not abbreviated. |
|
MonthName |
Returns a string value containing the name of the specified month. |
|
Now |
Returns a value containing the current date and time according to your system. |
|
Second |
Returns an integer value from 0 through 59 representing the second of the minute. |
|
TextToDate |
Converts the specified date string, using the specified format string, to a date. |
|
TextToDatetime |
Converts the specified date string, using the specified format string, to a date/time |
|
TimeOfDay |
Returns a Date value containing the current time of day according to your system (with date part set to 01/01/0001). |
|
Timer |
Returns a Double value representing the number of seconds elapsed since midnight. |
|
TimeSerial |
Returns a Date value representing a specified hour, minute, and second, with the date information set relative to January 1 of the year 1. |
|
TimeString |
Returns or sets a string value representing the current time of day according to your system. |
|
TimeValue |
Returns a Date value containing the time information represented by a string, with the date information set to January 1 of the year 1. |
|
ToDate |
Returns a DateTime that is set to the specified date and time in the current era. |
|
ToDateTime |
Returns a DateTime that is set to the specified date and time in the current era. |
|
Today |
Return current date (with time part set to 00:00:00) |
|
ToFourDigitYear |
Converts the specified year to a four-digit year by using the TwoDigitYearMax property to determine the appropriate century. |
|
Weekday |
Returns an integer value containing a number representing the day of the week. |
|
WeekdayName |
Returns a string value containing the name of the specified weekday. |
|
Year |
Returns an integer value from 1 through 9999 representing the year. |