Test if the variable is a datetime |
Member of String Intrinsic Functions (PRIM_LIBI.IStringIntrinsics)
Name | Type | Data Type | Description |
|---|---|---|---|
Result | *Result (Optional) | Boolean | True if the variable is a valid datetime |
Format | *Input (Optional) | Enumeration | Format of the datetime |
IsDateTime will return True if the variable can be converted to a valid datetime in the specified format.
IsDateTime will often be used before AsDateTime to better handle potential errors.
Enum Value | Description |
|---|---|
CCYYDDMMHHMMSS | e.g. "20153105113045" |
CCYYMMDDHHMMSS | e.g. "20150531113045" |
HHMMSSDDMMCCYY | e.g. "11304531052015" |
HHMMSSDDMMYY | e.g. "113045310515" |
ISO | e.g. "2015-05-31 11:30:45" |
Localized_SQL | e.g. "2015-05-31 11:30:45" |
SQL | e.g. "2015-05-31 11:30:45" |
TZ | e.g. "2015-05-20T01:16:05Z" or "2015-05-20T01:18:17+10:00" if appending the UTC offset |
In this example, IsDateTime expects a variable in the format CCYYMMDDHHMMSS
If (#Variable.IsDateTime(CCYYMMDDHHMMSS)
#Datetime := #Variable.AsDateTime(CCYYMMDDHHMMSS)
Endif