DateValue

<< Click to Display Table of Contents >>

Navigation:  Date / Time functions >

DateValue

Description

Returns a date value from the string expression representing a date.

Syntax

DateValue(date)

 

Parameter

Part

Type

Description

date

String

Required. String expression representing a date from January 1, 100 through December 31, 9999.
However, date can also be any expression that can represent a date, a time, or both a date and time, in that range.

Example

Dim MyDate As Date

MyDate = DateValue("May 20, 1963")   ' Return a date