Description
Resets the ISO datetime string to the beginning of the month specified in the string.Syntax
ISOToMonth(datetime_string)
Examples
ISOToMonth('2009-01-07T01:07:01.000Z') returns 2009-01-01T00:00:00.000Z
Functions A to Z
ETL: ISOToMonth
Truncate an ISO datetime string to the first day of its month. Use ISOTOMONTH for monthly aggregations in Integrate.io ETL pipeline expressions.
Last modified on April 20, 2026