This article applies to:

ISOTime Function

Description:

Convert a text value representing an ISO date/time to a time 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 time is not a valid time.

Returns:

Time

Parameter:

Parameter	Data Type	Description
1	Text	ISO datetime text of the form "YYYY-MM-DD HH:MM:SS"

Example:

When using functions inside a field, remember the field brackets:

{ISOTime(VariableName)}

Expression	Result
ISOTime("2000-02-29 15:30:00")	Time(15,30,0)