https://community.blueprism.com/t5/Product-Forum/Date-Functions/m-p/90320#M40554 Thanks Fri, 06 Apr 2018 14:43:00 GMT MOHANO_S 2018-04-06T14:43:00Z https://community.blueprism.com/t5/Product-Forum/Date-Functions/m-p/90318#M40552 DateAdd({Interval}, {Number}, {Date})   How can we define  the number for  add the Day,Weeks,Months and Year in the "Interval".. It defined as number I am aware Like YYYY, MM, DD supports in DB and it's a varchar,   Wed, 04 Apr 2018 19:18:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Functions/m-p/90318#M40552 MOHANO_S 2018-04-04T19:18:00Z https://community.blueprism.com/t5/Product-Forum/Date-Functions/m-p/90319#M40553 I struggled with this originally too. The time interval is defined as such: (this can be found with F1 Help in the Calculation stage) Interval DateAdd DateDiff 0             Year          Year 1             Week        Week of year (Calendar week) 2            (n/a)          Weekday (Full 7 day week) 3            (n/a)          Second 4            Quarter     Quarter 5            Month        Month 6            (n/a)          Minute 7            (n/a)          Hour 8            (n/a)          Day of year 9            (n/a)          Day Wed, 04 Apr 2018 21:08:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Functions/m-p/90319#M40553 ShirleyZhang1 2018-04-04T21:08:00Z https://community.blueprism.com/t5/Product-Forum/Date-Functions/m-p/90320#M40554 Thanks Fri, 06 Apr 2018 14:43:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Functions/m-p/90320#M40554 MOHANO_S 2018-04-06T14:43:00Z