https://community.alteryx.com/t5/Alteryx-Server-Discussions/Calculating-Future-Date-with-last-year-data-dynamically/m-p/1280320#M15524 <P>I have Data like below,</P><TABLE><TBODY><TR><TD>Business</TD><TD>Date</TD><TD>Sales</TD></TR><TR><TD>Bank</TD><TD>12/31/2024</TD><TD>4044</TD></TR><TR><TD>Bank</TD><TD>12/31/2025</TD><TD>4008</TD></TR><TR><TD>Bank</TD><TD>12/31/2026</TD><TD>3906</TD></TR><TR><TD>Bank</TD><TD>12/31/2027</TD><TD>3935</TD></TR><TR><TD>Bank</TD><TD>12/31/2028</TD><TD>5454</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to Calculate data for 12/31/2029 which should be equal to 2028 dynamically. for example if the workflow is ran next year the 2029 data will be passed to 2030 and next year 2030 data will be equal to 2031 and so on. How can we achieve this in alteryx?</P> Mon, 03 Jun 2024 14:17:42 GMT Alteryxexpert 2024-06-03T14:17:42Z https://community.alteryx.com/t5/Alteryx-Server-Discussions/Calculating-Future-Date-with-last-year-data-dynamically/m-p/1280320#M15524 <P>I have Data like below,</P><TABLE><TBODY><TR><TD>Business</TD><TD>Date</TD><TD>Sales</TD></TR><TR><TD>Bank</TD><TD>12/31/2024</TD><TD>4044</TD></TR><TR><TD>Bank</TD><TD>12/31/2025</TD><TD>4008</TD></TR><TR><TD>Bank</TD><TD>12/31/2026</TD><TD>3906</TD></TR><TR><TD>Bank</TD><TD>12/31/2027</TD><TD>3935</TD></TR><TR><TD>Bank</TD><TD>12/31/2028</TD><TD>5454</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to Calculate data for 12/31/2029 which should be equal to 2028 dynamically. for example if the workflow is ran next year the 2029 data will be passed to 2030 and next year 2030 data will be equal to 2031 and so on. How can we achieve this in alteryx?</P> Mon, 03 Jun 2024 14:17:42 GMT https://community.alteryx.com/t5/Alteryx-Server-Discussions/Calculating-Future-Date-with-last-year-data-dynamically/m-p/1280320#M15524 Alteryxexpert 2024-06-03T14:17:42Z https://community.alteryx.com/t5/Alteryx-Server-Discussions/Calculating-Future-Date-with-last-year-data-dynamically/m-p/1280379#M15525 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/565436">@Alteryxexpert</a>&nbsp;it sounds like what you want is to calculate the data for a year, then add 1 year to the date column, which you could do with a formula. Is that what you are looking to do?</P> Mon, 03 Jun 2024 15:28:30 GMT https://community.alteryx.com/t5/Alteryx-Server-Discussions/Calculating-Future-Date-with-last-year-data-dynamically/m-p/1280379#M15525 cpet13 2024-06-03T15:28:30Z