| Function | Description |
|---|---|
| Date | Returns the current system date |
| DateAdd | Adds a time/date interval to a date and then returns the date |
| DateDiff | Returns the difference between two dates |
| DatePart | Returns a specified part of a date (as an integer) |
| DateSerial | Returns a date from the specified parts (year, month, and day values) |
| DateValue | Returns a date based on a string |
| Day | Returns the day of the month for a given date |
| Format | Formats a date value with the specified format |
| Hour | Returns the hour part of a time/datetime |
| Minute | Returns the minute part of a time/datetime |
| Month | Returns the month part of a given date |
| MonthName | Returns the name of the month based on a number |
| Now | Returns the current date and time based on the computer's system date and time |
| Second | Returns the seconds part of a time/datetime |
| Time | Returns the current system time |
| TimeSerial | Returns a time from the specified parts (hour, minute, and second value) |
| TimeValue | Returns a time based on a string |
| Weekday | Returns the weekday number for a given date |
| WeekdayName | Returns the weekday name based on a number |
| Year | Returns the year part of a given date |