DOUBLE TO DATE

[AmAm]

Hi, 

I have a date in excel but in Alteryx it switch to double. I want to keep it a date.

    In Alteryx                                     What I am trying to get

                                            (this is how it is in the excel file when I input it)

               

[DataNath · Accepted solution]

Try using the following and see how you get on:

datetimeformat(ToDateTime(tonumber(<Insert field name>)), '%B %d, %Y %I:%M:%S %p')

The ToNumber() may not be needed in your case. If not, just remove that and try:

datetimeformat(ToDateTime(<Insert field here>), '%B %d, %Y %I:%M:%S %p')

Iirc, Alteryx can't handle milliseconds, though I may be mistaken.

[AmAm]

@DataNath  you saved the day .... Thanks man!!

[DataNath]

No problem! Happy to help :)