ISDATE

Syntax

ISDATE (date)

Description

Determines whether date is a valid date.

Arguments

date A date and time as a DateTime or String

Returns

Returns True if the date is data type DateTime or can be converted to a DateTime, otherwise, it returns False.

Examples

ISDATE ("February 12, 1969")

Returns: True

ISDATE ("John Doe")

Returns: False

Related Topics

DateTime Functions

GETDATETIME

TODATETIME