Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
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
Free Trial

Alteryx Designer Desktop Discussions

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

Convert 31.12.2021 to 31-12-2021

Redzapplin
8 - Asteroid
‎02-01-2021 05:00 AM

How do I Convert string - 31.12.2021 to 31-12-2021 date format?

Reply
2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor
‎02-01-2021 05:08 AM

Hi @Redzapplin,

 

You need to use this formula:

 

DateTimeParse([Date],'%d.%m.%yyyy')

Date.yxmd
Reply
0 Likes
Jean-Balteryx
16 - Nebula
16 - Nebula
‎02-01-2021 05:13 AM

Hi @Redzapplin ,

 

In addition to the right answer from @Emil_Kos , you can also use a DateTime tool to transform it in standard Alteryx data format and manipulate it as a Date field :

 

Capture d’écran 2021-02-01 à 14.13.17.png

Reply
Labels