ISODate Function
Description:
Convert a text value representing an ISO date/time to a date value.
An ISO date/time always has 19 characters and is always of the form:
"YYYY-MM-DD HH:MM:SS"
note
This function is non-evaluable if the text value is not of this form, or if the date is not a valid date.
Returns:
Date
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Text | The text value. |
Example:
When using functions inside a field, remember the field brackets:
{ISODate(VariableName)}
Expression | Result |
|---|---|
ISODate("2000-02-29 15:30:00") | Date( 2000, 2, 29 ) |
Related Content
-
Date Functions
Format:
Article,
1 min read