ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

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

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!!

pedrodrfaria
13 - Pulsar

HI @Goran 

 

Please see attached for the WF.

pedrodrfaria_0-1615313640508.png

 

jamielaird
14 - Magnetar

deleting my duplicate response

MarqueeCrew
19 - Altair
19 - Altair

@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.
Labels