Date and Time Quick Reference

The following table lists methods for date and time information.

Statement	Purpose	Reference
Date	Converts an expression to the data type variant of type date.	Convert Number to Date Method
Date = expression	Sets the computer date.	Set Date Method
DateSerial	Converts a number to a date.	Convert Serial Number to Date Method
DateValue	Converts a string to a date.	Convert String to Date Method
Day	Returns the day component of a date and time value.	Extract Day From Date-Time Value Method
Hour	Returns the hour of day component of a date and time value.	Extract Hour From Date-Time Value Method
Minute	Returns the minute component of a date and time value.	Extract Minute From Date-Time Value Method
Month	Returns the month component of a date and time value.	Extract Month From Date-Time Value Method
Now	Returns the current date and time.	Get Current Date and Time Method
Second	Returns the second component of a date and time value.	Extract Second From Date-Time Value Method
Time	Returns the current time.	Get Current Time Method
Time = expression	Sets the current time.	Set Time Method
Timer	Returns the number of seconds since midnight.	Get Current Seconds Method
TimeSerial	Returns the time for a specific hour, minute, and second.	Get Serial Time Method
TimeValue	Converts a string to time.	Convert String to Time Method
Weekday	Returns the day of the week for the specified date and time value.	Extract Weekday From Date-Time Value Method
Year	Returns the year component of a date and time value.	Extract Year From Date-Time Value Method