Skip to main content

​
Description

Resets the ISO datetime string to the beginning of the week (Monday) specified in the string.

​
Syntax

ISOToWeek(datetime_string)

​
Examples

ISOToWeek('2009-01-07T01:07:01.000Z') returns 2009-01-05T00:00:00.000Z

​
Notes

The datetime_string must be in ISO 8601 date time format, otherwise the job will fail. See Using ISO 8601 date/time functions.

​
Return value datatype

String

​
Impact of null value

If input is null, returns null.
Last modified on April 20, 2026