add 365 days to a specific date

[rejb]

I have tried the following in bold DateTimeAdd([ORIGINAL_INCEPTION_DATE],"+365",d) but it fails every time, where am i going wrong please, original_inception_date is 2021-04-20

[atcodedog05]

Hi @rejb 

Formula should be

DateTimeAdd([ORIGINAL_INCEPTION_DATE],365,"days")

You can refer this link for list of formulas

https://help.alteryx.com/20212/designer/datetime-functions

Hope this helps : )

[Maskell_Rascal]

In addition to the resource that @atcodedog05 provided, I would recommend bookmarking this one as well. It has an excellent table at the top that shows the results of the different <format string> options. 

https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm

[apathetichell]

You might consider using datetimeadd([yourdatefield],1,"years") instead of 365 days - if you have a leap year mixed in you may not get the result you want - ie 365 days from 2020-01-01 is 2020-12-31 - not 2021-01-01

[rejb]

thank you