Skip to main content

​
Description

Adds the value represented by the duration expression to the datetime_string. Syntax ISOAddDuration(datetime_string, duration)

​
Arguments

datetime_string - string expression in ISO 8601 format. duration - duration string expression in ISO 8601 format. See https://en.wikipedia.org/wiki/ISO_8601#Durations

​
Examples

ISOAddDuration('2007-03-05T03:05:03.000Z', 'P1D') returns 2007-03-06T03:05:03.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