How to use SUBYEARS function in vFlow2.0?

Why do we use SUBYEARS function in vFlow2.0?

1 Like

The SUBYEARS function subtracts a given number of years from a specified date. For example, if the input date is 05/3/24 and you subtract 2 years , the function processes the subtraction and returns 05/03/22.

Syntax- SUBYEARS(date, dateFormat, NoOfYears,outPutDateFormat)

Example- SUBYEARS(“2024-3-05”, “yyyy-MM-dd”,“2”,“dd/MM/yyyy”)

1 Like