SUBTRACT_YEARS
Last updated
Was this helpful?
Last updated
Was this helpful?
SUBTRACT_YEARS
takes a date, from either an information or in , and a number of years to subtract, and returns a date with the given number of years subtracted.
In the special case that the new year doesn't contain the original date (e.g. when subtracting a year from the leap day 29.02.2016) the new date will have the same number of days from the beginning of the year (e.g. 01.03.2015 in the earlier example).
This expression returns the current date 18 years ago.
This returns the 1st January 1982
If you specify not just a date, but a date and time in ISO8601 format, the function includes the time in the calculation.
This returns also the 1st January 1982, but at 9:35:23, so 1982-01-01T09:35:23
.