Transforming Date formatted as String to Date format

[ddye]

Hi, I am having some trouble using the multi-field formula reformat a date from a string to an actual date data type.  I have a few different dates all coming in as strings that are in different formats, and I would like to use the multi-field formula tool to convert them all to date data type.  

Here are the two different string formats.

          GL Date             Open Date

2007/11/30 00:00:00;   1/17/2008;  

When I run these two fields through the multi-field formula (DateTimeParse([_CurrentField_],'%Y/%m/$m')), I get:

         GL Date             Open Date

       2007-11-01                 Null

Thanks very much for your time.

[JohnJPS · Accepted solution]

The formula you tried recognizes only a specifc format... I would recommend trying the BB-Date macro, which can parse numerous variations of date/datetime formats. 

[ddye]

That is perfect, thank you very much for pointing that out.

I might bring up to someone at alteryx that I spent a lot of time googling for something like this.  I guess I should just come to the message board first for this sort of thing.

Thank you again.