Tests the value of an expression to determine whether it is a date/time value.

Syntax

IsDate ( expr )

Elements

expr

Any expression.

IsDate returns TRUE (-1) if expr is any of the following:

• A Variant value of DataType 7 (Date/Time)
• A Variant value of type String, where the string represents a valid date/time value
• A String value representing a valid date/time value

Usage

A date/time value stored in a Variant is an 8-byte floating-point value. The integer part represents a serial day counted from Jan 1, 100 AD. Valid dates are represented by integers between -657434 (representing Jan 1, 100 AD) and 2958465 (representing Dec 31, 9999 AD). The fractional part represents the time as a fraction of a day, measured from time 00:00:00 (midnight on the previous day). In this representation of date/time values, day 1 is the date December 31, 1899.

Example
See Also

LotusScript Language Reference: I through L
CDat function
IsNumeric function
IsScalar function

Glossary