how do you convert a v string date to a standard Alteryx date

[jthompson789]

The format of the date is: 09-Aug-2018.

What tool or function would I use to convert this to a Alteryx date format?

[JohnJPS · Accepted solution]

Try a Formula Tool with 

DateTimeParse("%d-%b-%Y")

Specify that the new variable you're creating should be a date.

Hope that helps!

John

[BenMoss]

I prefer the datetime tool, here you can specify the format of your string and Alteryx will perform the conversion for you.

Under the hood it's basically doing as the post above though!

Ben

[jthompson789]

Great suggestion. I just had to figure out were to put the field name in the calculation. Here is the complete formula I used:

DateTimeParse([date],"%d-%b-%Y")

I just started using Alteryx this week so I'm pretty new. This tip is going into my OneNote folder for Alteryx tips on formulas.

Thanks again for the quick help.

[jthompson789]

Hi Ben, Thanks for the suggestion. I did try the date time parse tool but it did want to convert my date format.