Date & Time Functions

The following functions are contained in this category:

Name
Description
CDate
Converts the value, specified as an argument, to a value of type 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 value of type Date for a specified year, month, and day.
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.
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.
Today
Returns a DateTime value containing the current date according to your system.

	Name	Description
	CDate	Converts the value, specified as an argument, to a value of type 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 value of type Date for a specified year, month, and day.
	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.
	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.
	Today	Returns a DateTime value containing the current date according to your system.