IsDate Function

Checks to see if the string expression contains a valid date and/or time.

IsDate (String )

Parameters

String  -  (Input, expression, Required)

A non-string will return False.

Return Value

Returns True if the string contains a valid date and/or time, otherwise False.

Examples

IsDate (“22 Feb 63”)	Returns True
IsDate (“abc”)	Returns False
IsDate (2-22-63)	Returns False
IsDate (Null)	Returns False
IsDate (Error)	Returns False

TIP:

Functions are specifically for use in the Macro Editor. Refer to Microsoft's official VB and JScript documentation for scripting equivalents.

See Also

Functions | UBound Function | IsArray function | IsEmpty function | IsError function | IsNull function | IsNumeric function | IsSpaces function | IsURL function

---

© 2004-2021 looksoftware. All rights reserved.