12. Add Years

Use this expression to add the number of years for the given date.

Syntax

Add Years (howmany, to_date, format_1) = output

Sample

1. Add Years (12, 12/12/1988, %d/%m/%Y) = 12/12/2000

2. Add Years (03, 1988/12/12, %Y/%m/%d) = 1991/12/12

Parameter Details

Input Parameter Name Description
howmany Number of days to be added.
*Monday is considered the start and Sunday to be end of the week
To_date Date for which the days must be added
Format_1 Date Format of the ‘To_date’ parameter
Did you find what you were looking for?

Automation Analytics and AI in a box

Contact Us

HfS Hot Vendor

Option3's Automation capabilities featured in HfS Research's Hot Vendors List for Q3, 2018

Access your copy here