| Date() | Converts a string whose value is a valid date to a value of datatype date. |
| DateTime() | Combines a date and a time value into a DateTime value. |
| DateTimeToNumber() | Converts a DateTime or Date to the number of days after 1899-12-30, as used by Excel and Microsoft ODBC drivers. |
| Day() | Obtains the day number of the month in a date value. |
| DayName() | Obtains the day of the week in a date value and returns the weekday’s name. |
| DayNameLocal() | Gets the day of the week in a date value and returns the weekday’s name in localized language. |
| DayNumber() | Gets the day of the week of a date value and returns the number of the weekday. |
| DaysAfter() | Return the number of days one date occurs after another. |
| FirstDayOfMonth() | Return the first day of the month as a date data type. |
| FirstDayOfWeekISO() | Get the first day of the week as a date data type. (ISO standard). |
| FirstDayOfWeekUS() | Get the first day of the week as a date data type. (US standard) |
| Hour() | Obtains the hour in a time value. The hour is based on a 24-hour clock. |
| HoursAfter() | Obtains the number of hours one datetime occurs after another. |
| IsDate() | Tests whether a string value is a valid date. |
| LastDayOfMonth() | Return the last day of the month as a date data type. |
| LastDayOfWeekUS() | Return the last day of the week as a date data type. (US standard) |
| LastDayOfWeekISO() | Return the last day of the week as a date data type. (ISO standard) |
| Minute() | Obtains the number of minutes in the minutes portion of a time value. |
| Month() | Gets the month of a date value. |
| MonthsAfter() | Return the number of months one date occurs after another. |
| MonthName() | Obtains the month of a date value and returns the month’s name. |
| MonthNameN() | Return the month’s name based on the months number (1-12). |
| Now() | Obtains the current time based on the system time of the client machine. |
| RelativeDateTime() | Obtains a datetime that occurs a specified number of seconds after or before another datetime. |
| RelativeMonth() | Obtains the date that occurs a specified number of months after or before another date. |
| RelativeYear() | Obtains the date that occurs a specified number of years after or before another date. |
| Second() | Obtains the number of seconds in the seconds portion of a time value. |
| SecondsAfter() | Gets the number of seconds one time occurs after another. |
| SecondsAfterDateTime() | Gets the number of seconds one datetime occurs after another. |
| Time() | Converts a string to a time datatype. |
| Today() | Returns the current system date, without a time. |
| Year() | Gets the year of a date value. |
| YearsAfter() | Return the number of years one date occurs after another. |
| WeekNumberISO() | Return the week number of a date value. (ISO standard) |
| WeekNumberUS() | Return the week number of a date value. (US standard) |
