How to convert String into Date

[Lizbhernan]

Hello,

I am working on a workflow in which I had to split data using a text to column tool and when I did that, the date split into 3. I then combined it in a formula tool using the formula below to give me a date.

[Detail Note1]+'/'+[Detail Note2]+'/'+[Detail Note3]

I am now trying to convert it into an actual date and I can't. I tried changing the format in a select tool, I also tried using a Todate() formula and that didn't work. Does anyone know how I can possibly do that?

I have shared my workflow for reference.

Thank you in advance for your help.

[OTrieger]

@Lizbhernan 

In the Parse Menu, you have Date Time tool, it will do the job

[Deano478]

@Lizbhernan You can also use a combination of DateTimeParse and DateTimeFormat in the formula tool to do this