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 DateTenorBucketsTenor GroupDateTime_OutDays NameType28/06/202411Y228/06/2024365 CoB DateV_String28/06/202422Y328/06/2024730 TenorByte28/06/202433Y428/06/20241095 BucketsString28/06/202444Y528/06/20241460 Tenor GroupByte28/06/202455Y628/06/20241825 DateTime_OutDate28/06/202477Y728/06/20242555 DaysV_String28/06/20241010Y828/06/20243650 28/06/20241515Y928/06/20245475 28/06/20242020Y1028/06/20247300 28/06/20242525Y1128/06/20249125 28/06/20243030Y1228/06/202410950 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. CoB28/06/2024 DateTenor Group628/06/20240 1228/12/20241 128/06/20252 228/06/20263 328/06/20274 427/06/20285 527/06/20296 727/06/20317 1026/06/20348 1525/06/20399 2023/06/204410 2522/06/204911 3021/06/205412 Any help would be much appreciated, Thanks Sures

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

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