We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to covert Multiple DATEs ( Data type : String) convert to Date format (DD:MM:YYYY)

Anjankumar2021
8 - Asteroid
‎03-23-2023 08:32 AM

How to covert Multiple DATEs ( Data type : String) convert to Date format (DD:MM:YYYY)

 

 

Anjankumar2021_0-1679585512247.png

 

Labels:
Reply
0 Likes
2 REPLIES 2
gaoa
11 - Bolide
‎03-23-2023 08:46 AM

Hi @Anjankumar2021 

You can use this formula: DateTimeFormat([Sale date],"%d/%m/%Y")

gaoa_0-1679586233296.png

Convert Date Formats.yxmd
Reply
KimLamNg
9 - Comet
‎03-23-2023 08:49 AM

You can transpose to have all the dates in one column then convert data type from string to date. However, the standard date format in Alteryx is "yyyy-mm-dd", so I don't think it possible to have the desired outcome.

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All