ISUNSPECIFIEDDATE

Syntax

ISUNSPECIFIEDDATE (date)

Description

Determines whether the kind property for date is set to unspecified. The kind property indicates whether a DateTime is local time, UTC time or unspecified where:

Arguments

date A date and time as a DateTime or String

Returns

Returns True if the kind property on date is set to 0, which indicates unspecified; otherwise returns False.

Remarks

If the kind property is set to anything other than 0, 1, or 2, a record error is returned.

Example

ISUNSPECIFIEDDATE (Account.CreatedDate)

Returns: True if the kind property is set to 0, indicating that it is unspecified.

Related Topics

DateTime Functions

GETDATETIME

TODATETIME