SUB_YEARS Operation

How to use the SUB_YEARS operation for Computed Attributes

Definition
Example
Syntax Guide
Formula In Use

 


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

 


Formula In Use

plytix-subyear-computed-attribute-formula

 


What's next? 



If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...

and please let us know 👇