This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
community Data Science Portal Alteryx.com
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

Alteryx Designer Discussions

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

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

Goran
7 - Meteor
‎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
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
19 - Altair
19 - Altair
‎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 reboot. Order shall return.
Reply
Labels