The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
communauté Alteryx IO MyAlteryx
alteryx Community
Search
annuler
Activer les suggestions
La fonction de suggestion automatique permet d'affiner rapidement votre recherche en suggérant des correspondances possibles au fur et à mesure de la frappe.
Affichage des résultats de 
Rechercher plutôt 
Vouliez-vous dire : 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

Date Value Converted to Double

Oniel182
Météore
‎03-04-2024 05:44 AM

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

Étiquettes :
Répondre
0 Compliments
2 RÉPONSES 2
alexnajm
19 - Altair
19 - Altair
‎03-04-2024 05:46 AM

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

Date Value Converted to Double.png

Répondre
0 Compliments
Oniel182
Météore
‎03-04-2024 05:53 AM

Thank you very much!

Répondre
0 Compliments
Étiquettes
Auteurs des meilleures solutions
Tout afficher