Date Editing from Excel

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

Workflow

Input

Date Time

Best Practices

Accepted answers

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

All comments

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703