CitectVBA Programming Reference > CitectVBA Function Reference > Declarations > IsDate

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