Date

Returns the current system date

DateAdd

Returns a date to which a specified time interval has been added

DateDiff

Returns the number of intervals between two dates

DatePart

Returns the specified part of a given date

DateSerial

Returns a Variant of subtype Date for a specified year, month, and day

DateValue

Returns a Variant of subtype Date

Day

Returns a whole number between 1 and 31, inclusive, representing the day of the month

Hour

Returns a whole number between 0 and 23, inclusive, representing the hour of the day

Minute

Returns a whole number between 0 and 59, inclusive, representing the minute of the hour

Month

Returns a whole number between 1 and 12, inclusive, representing the month of the year

MonthName

Returns a string indicating the specified month

Now

Returns the current date and time according to the setting of your computer's system date and time

Second

Returns a whole number between 0 and 59, inclusive, representing the second of the minute

Time

Returns a Variant of subtype Date indicating the current system time

TimeSerial

Returns a Variant of subtype Date containing the time for a specific hour, minute, and second

TimeValue

Returns a Variant of subtype Date containing the time

Weekday

Returns a whole number representing the day of the week

WeekdayName

Returns a string indicating the specified day of the week

Year

Returns a whole number representing the year