Description
Resets the ISO datetime string to the beginning of the year specified in the string.Syntax
ISOToYear(datetime_string)
Examples
ISOToYear('2009-01-07T01:07:01.000Z') returns 2009-01-01T00:00:00.000Z
Functions A to Z
ETL: ISOToYear
Truncate an ISO datetime string to January 1st of its year. Use ISOTOYEAR for yearly aggregations in Integrate.io ETL pipeline expressions.
Last modified on June 1, 2026