Using ISO 8601 string functions

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)