How to add a column with the date

[IsaacRamiro]

Hello,

I hope somebody can help me. I need to sum the days of warranty to the initial day and plug it to a master file i am doing.

Thanks an best regards.

Ramiro.

[Luke_C]

Hi @IsaacRamiro 

You need to use a few date time formulas:

1. Use DateTimeParse to turn the date into a proper alteryx readable date
2. DateTimeAdd to add the days of warranty
3. DateTimeFormat to format back to your desired format

More info on datetime formulas: DateTime Functions | Alteryx Help

DateTimeFormat(DateTimeAdd(datetimeparse([Date],'%d/%m/%Y'),[Days of warranty],'days'),'%d/%m/%Y')

[binuacs]

@IsaacRamiro another way of doing with the DateTime tool. I agree that @Luke_C  method's is the simple one but I want to show you the other methods as well.