https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-new-date-column-by-adding-Column-Days-to-a-date/m-p/1326816#M330865 <P>Hi all</P><P>Need some help pls resolving what I thought was a straightforward problem, I've got the below data in my workflow (I've added what data type the columns are on the right)&nbsp;</P><P>&nbsp;</P><DIV class="">&nbsp;</DIV><P>The new column I'm trying to create has to be the Days + the CoB Date&nbsp; (or DateTime_Out in Date type)</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CoB Date</TD><TD>Tenor</TD><TD>Buckets</TD><TD>Tenor Group</TD><TD>DateTime_Out</TD><TD>Days</TD><TD>&nbsp;</TD><TD>Name</TD><TD>Type</TD></TR><TR><TD>28/06/2024</TD><TD>1</TD><TD>1Y</TD><TD>2</TD><TD>28/06/2024</TD><TD>365</TD><TD>&nbsp;</TD><TD>CoB Date</TD><TD>V_String</TD></TR><TR><TD>28/06/2024</TD><TD>2</TD><TD>2Y</TD><TD>3</TD><TD>28/06/2024</TD><TD>730</TD><TD>&nbsp;</TD><TD>Tenor</TD><TD>Byte</TD></TR><TR><TD>28/06/2024</TD><TD>3</TD><TD>3Y</TD><TD>4</TD><TD>28/06/2024</TD><TD>1095</TD><TD>&nbsp;</TD><TD>Buckets</TD><TD>String</TD></TR><TR><TD>28/06/2024</TD><TD>4</TD><TD>4Y</TD><TD>5</TD><TD>28/06/2024</TD><TD>1460</TD><TD>&nbsp;</TD><TD>Tenor Group</TD><TD>Byte</TD></TR><TR><TD>28/06/2024</TD><TD>5</TD><TD>5Y</TD><TD>6</TD><TD>28/06/2024</TD><TD>1825</TD><TD>&nbsp;</TD><TD>DateTime_Out</TD><TD>Date</TD></TR><TR><TD>28/06/2024</TD><TD>7</TD><TD>7Y</TD><TD>7</TD><TD>28/06/2024</TD><TD>2555</TD><TD>&nbsp;</TD><TD>Days</TD><TD>V_String</TD></TR><TR><TD>28/06/2024</TD><TD>10</TD><TD>10Y</TD><TD>8</TD><TD>28/06/2024</TD><TD>3650</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>28/06/2024</TD><TD>15</TD><TD>15Y</TD><TD>9</TD><TD>28/06/2024</TD><TD>5475</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>28/06/2024</TD><TD>20</TD><TD>20Y</TD><TD>10</TD><TD>28/06/2024</TD><TD>7300</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>28/06/2024</TD><TD>25</TD><TD>25Y</TD><TD>11</TD><TD>28/06/2024</TD><TD>9125</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>28/06/2024</TD><TD>30</TD><TD>30Y</TD><TD>12</TD><TD>28/06/2024</TD><TD>10950</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><DIV class="">&nbsp;</DIV><P>My output has to be the date column below. Think I'm getting stuck trying to add 'Days' in 'V-String' to a 'Date' type column? Using 'Tenor Group 8' from above table my output should be 28/06/2024 + 3,650 = 26/06/2034.&nbsp;</P><P>&nbsp;</P><DIV class="">&nbsp;</DIV><TABLE><TBODY><TR><TD>CoB</TD><TD>28/06/2024</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Date</TD><TD>Tenor Group</TD></TR><TR><TD>6</TD><TD>28/06/2024</TD><TD>0</TD><TD>&nbsp;</TD></TR><TR><TD>12</TD><TD>28/12/2024</TD><TD>1</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>28/06/2025</TD><TD>2</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>28/06/2026</TD><TD>3</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>28/06/2027</TD><TD>4</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>27/06/2028</TD><TD>5</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>27/06/2029</TD><TD>6</TD><TD>&nbsp;</TD></TR><TR><TD>7</TD><TD>27/06/2031</TD><TD>7</TD><TD>&nbsp;</TD></TR><TR><TD>10</TD><TD>26/06/2034</TD><TD>8</TD><TD>&nbsp;</TD></TR><TR><TD>15</TD><TD>25/06/2039</TD><TD>9</TD><TD>&nbsp;</TD></TR><TR><TD>20</TD><TD>23/06/2044</TD><TD>10</TD><TD>&nbsp;</TD></TR><TR><TD>25</TD><TD>22/06/2049</TD><TD>11</TD><TD>&nbsp;</TD></TR><TR><TD>30</TD><TD>21/06/2054</TD><TD>12</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><DIV class="">&nbsp;</DIV><P>Any help would be much appreciated,&nbsp;</P><P>Thanks</P><P>Sures&nbsp;</P><P>&nbsp;</P> Tue, 08 Oct 2024 22:05:48 GMT sureslala 2024-10-08T22:05:48Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-new-date-column-by-adding-Column-Days-to-a-date/m-p/1326816#M330865 <P>Hi all</P><P>Need some help pls resolving what I thought was a straightforward problem, I've got the below data in my workflow (I've added what data type the columns are on the right)&nbsp;</P><P>&nbsp;</P><DIV class="">&nbsp;</DIV><P>The new column I'm trying to create has to be the Days + the CoB Date&nbsp; (or DateTime_Out in Date type)</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CoB Date</TD><TD>Tenor</TD><TD>Buckets</TD><TD>Tenor Group</TD><TD>DateTime_Out</TD><TD>Days</TD><TD>&nbsp;</TD><TD>Name</TD><TD>Type</TD></TR><TR><TD>28/06/2024</TD><TD>1</TD><TD>1Y</TD><TD>2</TD><TD>28/06/2024</TD><TD>365</TD><TD>&nbsp;</TD><TD>CoB Date</TD><TD>V_String</TD></TR><TR><TD>28/06/2024</TD><TD>2</TD><TD>2Y</TD><TD>3</TD><TD>28/06/2024</TD><TD>730</TD><TD>&nbsp;</TD><TD>Tenor</TD><TD>Byte</TD></TR><TR><TD>28/06/2024</TD><TD>3</TD><TD>3Y</TD><TD>4</TD><TD>28/06/2024</TD><TD>1095</TD><TD>&nbsp;</TD><TD>Buckets</TD><TD>String</TD></TR><TR><TD>28/06/2024</TD><TD>4</TD><TD>4Y</TD><TD>5</TD><TD>28/06/2024</TD><TD>1460</TD><TD>&nbsp;</TD><TD>Tenor Group</TD><TD>Byte</TD></TR><TR><TD>28/06/2024</TD><TD>5</TD><TD>5Y</TD><TD>6</TD><TD>28/06/2024</TD><TD>1825</TD><TD>&nbsp;</TD><TD>DateTime_Out</TD><TD>Date</TD></TR><TR><TD>28/06/2024</TD><TD>7</TD><TD>7Y</TD><TD>7</TD><TD>28/06/2024</TD><TD>2555</TD><TD>&nbsp;</TD><TD>Days</TD><TD>V_String</TD></TR><TR><TD>28/06/2024</TD><TD>10</TD><TD>10Y</TD><TD>8</TD><TD>28/06/2024</TD><TD>3650</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>28/06/2024</TD><TD>15</TD><TD>15Y</TD><TD>9</TD><TD>28/06/2024</TD><TD>5475</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>28/06/2024</TD><TD>20</TD><TD>20Y</TD><TD>10</TD><TD>28/06/2024</TD><TD>7300</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>28/06/2024</TD><TD>25</TD><TD>25Y</TD><TD>11</TD><TD>28/06/2024</TD><TD>9125</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>28/06/2024</TD><TD>30</TD><TD>30Y</TD><TD>12</TD><TD>28/06/2024</TD><TD>10950</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><DIV class="">&nbsp;</DIV><P>My output has to be the date column below. Think I'm getting stuck trying to add 'Days' in 'V-String' to a 'Date' type column? Using 'Tenor Group 8' from above table my output should be 28/06/2024 + 3,650 = 26/06/2034.&nbsp;</P><P>&nbsp;</P><DIV class="">&nbsp;</DIV><TABLE><TBODY><TR><TD>CoB</TD><TD>28/06/2024</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Date</TD><TD>Tenor Group</TD></TR><TR><TD>6</TD><TD>28/06/2024</TD><TD>0</TD><TD>&nbsp;</TD></TR><TR><TD>12</TD><TD>28/12/2024</TD><TD>1</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>28/06/2025</TD><TD>2</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>28/06/2026</TD><TD>3</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>28/06/2027</TD><TD>4</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>27/06/2028</TD><TD>5</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>27/06/2029</TD><TD>6</TD><TD>&nbsp;</TD></TR><TR><TD>7</TD><TD>27/06/2031</TD><TD>7</TD><TD>&nbsp;</TD></TR><TR><TD>10</TD><TD>26/06/2034</TD><TD>8</TD><TD>&nbsp;</TD></TR><TR><TD>15</TD><TD>25/06/2039</TD><TD>9</TD><TD>&nbsp;</TD></TR><TR><TD>20</TD><TD>23/06/2044</TD><TD>10</TD><TD>&nbsp;</TD></TR><TR><TD>25</TD><TD>22/06/2049</TD><TD>11</TD><TD>&nbsp;</TD></TR><TR><TD>30</TD><TD>21/06/2054</TD><TD>12</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><DIV class="">&nbsp;</DIV><P>Any help would be much appreciated,&nbsp;</P><P>Thanks</P><P>Sures&nbsp;</P><P>&nbsp;</P> Tue, 08 Oct 2024 22:05:48 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-new-date-column-by-adding-Column-Days-to-a-date/m-p/1326816#M330865 sureslala 2024-10-08T22:05:48Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-new-date-column-by-adding-Column-Days-to-a-date/m-p/1327399#M331071 <P>You just need the DateTimeAdd function! And yes, the days should be numeric: DateTimeAdd([Date], [Days], 'days')</P><P>&nbsp;</P><P>Make sure your Date column is also the correct date data type in Alteryx!</P> Thu, 10 Oct 2024 00:23:09 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-new-date-column-by-adding-Column-Days-to-a-date/m-p/1327399#M331071 alexnajm 2024-10-10T00:23:09Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-new-date-column-by-adding-Column-Days-to-a-date/m-p/1327411#M331075 <P>Hi&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/279101">@sureslala</a>,<BR />From what I understood from your explanation, here is the solution.&nbsp;</P><P>&nbsp;</P><DIV class="">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Formula Tool Config.png" style="width: 511px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/378885i381EAD9279D70BBB/image-size/large?v=v2&amp;px=999" role="button" title="Formula Tool Config.png" alt="Formula Tool Config.png" /></span></P> Thu, 10 Oct 2024 01:09:23 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-new-date-column-by-adding-Column-Days-to-a-date/m-p/1327411#M331075 alibink 2024-10-10T01:09:23Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-new-date-column-by-adding-Column-Days-to-a-date/m-p/1327559#M331098 <P>Thank you Alibink and Alexnajm! The workflow works! Thanks again for your assitance!&nbsp;</P> Thu, 10 Oct 2024 09:50:09 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-new-date-column-by-adding-Column-Days-to-a-date/m-p/1327559#M331098 sureslala 2024-10-10T09:50:09Z