Create new date column by adding Column [Days] to a date

[sureslala]

Hi all

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) 

The new column I'm trying to create has to be the Days + the CoB Date  (or DateTime_Out in Date type)

CoB Date	Tenor	Buckets	Tenor Group	DateTime_Out	Days		Name	Type
28/06/2024	1	1Y	2	28/06/2024	365		CoB Date	V_String
28/06/2024	2	2Y	3	28/06/2024	730		Tenor	Byte
28/06/2024	3	3Y	4	28/06/2024	1095		Buckets	String
28/06/2024	4	4Y	5	28/06/2024	1460		Tenor Group	Byte
28/06/2024	5	5Y	6	28/06/2024	1825		DateTime_Out	Date
28/06/2024	7	7Y	7	28/06/2024	2555		Days	V_String
28/06/2024	10	10Y	8	28/06/2024	3650
28/06/2024	15	15Y	9	28/06/2024	5475
28/06/2024	20	20Y	10	28/06/2024	7300
28/06/2024	25	25Y	11	28/06/2024	9125
28/06/2024	30	30Y	12	28/06/2024	10950

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. 

CoB	28/06/2024
	Date	Tenor Group
6	28/06/2024	0
12	28/12/2024	1
1	28/06/2025	2
2	28/06/2026	3
3	28/06/2027	4
4	27/06/2028	5
5	27/06/2029	6
7	27/06/2031	7
10	26/06/2034	8
15	25/06/2039	9
20	23/06/2044	10
25	22/06/2049	11
30	21/06/2054	12

Any help would be much appreciated, 

Thanks

Sures 

[alexnajm]

You just need the DateTimeAdd function! And yes, the days should be numeric: DateTimeAdd([Date], [Days], 'days')

Make sure your Date column is also the correct date data type in Alteryx!

[alibink · Accepted solution]

Hi @sureslala,
From what I understood from your explanation, here is the solution. 

[sureslala]

Thank you Alibink and Alexnajm! The workflow works! Thanks again for your assitance!