Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Value Converted to Double

Oniel182
7 - Meteor

Hello, When I load my Raw data (in Excel File) into Alteryx the Date value automatically changes to "Double" type, now I'm looking a way to convert it to the correct date format but couldn't find a way, see sample value below. By the way, I'm new here hoping someone can provide guidance. thanks!

 

45323
45328
45335
45336
45338
45343

 

45323.707973
45328.137911
45328.793062
45335.506424
45336.61558
45336.714422

2 REPLIES 2
alexnajm
16 - Nebula
16 - Nebula

It's just the Excel numeric date format being shown in Alteryx - the ToDate function should work well!

Date Value Converted to Double.png

Oniel182
7 - Meteor

Thank you very much!

Labels