IsDate

Determines if an expression can be converted to a date.

The required Date argument is a Variant containing a date expression or string expression recognizable as a date or time value.

Syntax

IsDate(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 Boolean True or False.

Related Functions

IsEmpty | IsNull | IsNumeric | VarType

Example

Dim x As String

Dim MArray As Integer, MCheck

MArray = 345

x = "January 1, 1987"

MCheck = IsDate(MArray)

MChekk = IsDate(x)

MArray1 = CStr(MArray)

MCheck1 = CStr(MCheck)

Print MArray1 & " is a date " & Chr(10) & MCheck

Print x & " is a date" & Chr(10) & MChekk