SUB_YEARS Operation

How to use the SUB_YEARS operation for Computed Attributes

Definition

The SUB_YEARS operation allows you to subtract years from a date.

Example

SUB_YEARS(‘2020-03-30’, 2)

Result:
2018-03-30

Syntax Guide

SUB_YEARS(date, years)

date - The date to subtract years from

years - The number of years you want to subtract from the date