Date and Time Functions

Date function

Determines the current system date according to the setting of the computer's system time.

Date Statement

Sets the current system date.

DateSerial function

Constructs a date value.

DateValuefunction

Calculates a date.

Day function

Calculates the day.

Hour function

Extracts the hours value from an expression (Time ).

Minute function

Extracts the minutes value from an expression (Time ).

Month function

Calculates the month.

Now function

Determines the current date and time according to the setting of the computer's system date and time.

Secondfunction

Extracts the seconds value from an expression (Time ).

Time function

Determines the current time according to the setting of the computer's system time.

Time (statement)

Sets the current system time.

Timer event

Used to track elapsed time.

TimeSerial function

Constructs an time value.

TimeValue function

Calculates a time.

WeekDay function

Calculates the weekday value of a date.

Year function

Calculates the year.