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

[Goran]

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]

HI @Goran 

Please see attached for the WF.

[jamielaird]

deleting my duplicate response

[MarqueeCrew]

@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