Date Editing from Excel

[ptraynor]

When you insert a date into Excel as a number eg. 1 March as 01/03 (UK), it will assume this is the current year eg. 01/03/2017. Can I use Alteryx to edit this data imported from excel to change the year i.e. change a whole data set from 2017 to 2013?

Thanks

Peter

[sjm · Accepted solution]

You can use this formula to subtract 4 years: DateTimeAdd(date,-4,'year')

[danrh]

You could add a Formula tool, select your field as the Output Column, and use DateTimeFormat([YourDate],'2013-%m-%d').