It is highly recommended to use the datetime data type based functions instead of the ISO 8601 string functions.
To prevent job failure when using any of the ISO 8601 date/time functions, make sure the value you're passing is in ISO 8601 date/time format by using the following syntax:
(IsISODatetime(datetime_field) ? ISOToHour(datetime_field) : null)