TODAY() formular pulling incorrectly from Microsoft Excel to Alteryx

[nk16096]

Hello,

I'm trying to pull through the following into Alteryx but it keeps on defaulting to 1905:

Excel:

Alteryx input data

Please advise?

[atcodedog05]

Hi @nk16096 

Can you please share a sample excel file where you are facing the issue.

Happy to help : )

[nk16096]

I actually managed to figure it out, thank you! 

I removed the TEXT() formula and then today's date feeds in correctly.

Then to put it in yyyy-mm format I added a formula in alteryx: left([Input date],7). This puts it into the correct format.

Thank you :)

[atcodedog05]

Hi @nk16096 

Happy to hear you were able to figure it out 🙂

Cheers and have a nice day!