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