DateValue

Calculates a date from the given date argument passed to the function. Date values in VBA are evaluated using the Gregorian Calendar. The DateValue function expects the argument value (Date)to be a string or any expression that can represent a date.

Syntax

DateValue(Date)

Date:

A string or expression that can represent a date value. This includes any combination of date literals, numbers that look like dates, strings that look like dates, and dates from functions.

Return Value

Returns a variant (of date data type) corresponding to the string date expression that was passed in.

Related Functions

TimeValue

Example

Dim varMyBDate
varMyBDate = DateValue("1958/07/08")
' stores date value.