String number to date

[vfernan6]

Hello Team

I got a quick question. I hope somebody can help me with this.

I load an excel file in alteryx. and one of the columns have dates. But, when I start to see the data in alteryx I see the regular number like 42887 and in excel is 2017-06-01.

Somebody know if there is any function in Alteryx can help to transfer the number to de date format?

I ready try with the Datetime tool

Thanks in Advance

[apathetichell · Accepted solution]

this should be in designer discussions - but the short is those are dates as ints (so days since 1899-12-30 or something) so try datetimeadd("1899-12-30",[yourfield],"days")

[FláviaB]

Thanks for you post, @vfernan6. For more visibility, I am moving it to our Designer Discussions board. Moving forward, feel free to send your questions in here so the Community members can help you out easily. 😉

[JosephSerpis]

Hi @vfernan6 you can also use the function to date to convert the Interger back to a date.

[vfernan6]

I do not try this one, but let me test it.