Number Intrinsic Functions - IsDateTime Method
Test if the variable is a datetime
Member of Number Intrinsic Functions (PRIM_LIBI.INumberIntrinsics)
| 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
Febuary 18 V14SP2