In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
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.

Converting DD MM YYYY String to YYYY-MM-DD Date

Goran
8 - Asteroid
‎03-09-2021 10:10 AM

Hi everyone,

 

I see this is a popular topic but I haven't been able to find a solution that works.  I converted an existing string column for dates from 1 - DD MMM YYYY to string column DD MM YYYY.  Now I'm trying to get this converted into an actual date column, preferably in YYYY-MM-DD format but every method I've tried either didn't do anything or resulted in Null.  

 

Any ideas?

 

Thanks!!

Labels:
Reply
3 REPLIES 3
pedrodrfaria
13 - Pulsar
‎03-09-2021 10:14 AM

HI @Goran 

 

Please see attached for the WF.

pedrodrfaria_0-1615313640508.png

 

Converting DD MM YYYY String to YYYY-MM-DD Date.yxmd
Reply
jamielaird
14 - Magnetar
‎03-09-2021 10:14 AM

deleting my duplicate response

Reply
MarqueeCrew
20 - Arcturus
20 - Arcturus
‎03-09-2021 12:34 PM

@Goran 

 

Here's a formula for you ... 

 

 

DateTimeParse(Right([Field1],11),"%d %b %Y")

 

 

Going the extra mile, let me show you how I got there ...

 

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Reply
Find a local User Group
designer new user guide
Labels
Top Solution Authors
View All