Description
Substracts the value represented by the duration expression from the datetime_string.
Syntax
ISOSubtractDuration(datetime_string, duration)
Arguments
datetime_string - string expression in ISO 8601 format.
duration - duration string in ISO 8601 format. See https://en.wikipedia.org/wiki/ISO_8601#Durations
Examples
ISOSubtractDuration('2007-03-05T03:05:03.000Z', 'P1D') returns 2007-03-04T03:05:03.000Z
Notes
The datetime_string must be in ISO 8601 date time format, otherwise the job will fail.
Return value datatype
String
Impact of null value
If input is null, returns null.Last modified on October 5, 2026
