how to Convert string date to date?

[jyothiki]

Hi all,

How to convert string date April 23, 2019, to date 2019-04-23. I used Datetimparse and formula tool but I'm getting error. Appreciate your help.

[TheOC · Accepted solution]

Hi @jyothiki 

find attached a workflow that achieves this with the datetime tool:

[JosephSerpis]

Hi @jyothiki I mocked up a workflow let me know what you think?

[Kenda · Accepted solution]

Hi @jyothiki 

I would recommend creating a new date field with a Formula tool and using the following expression:

DateTimeParse([Field1],"%B %d, %Y")

I always have this webpage handy when working with dates.

Hope this helps!

[jyothiki]

Thank you. I got it