Using multiple Date Time tools. Is there a simpler way to convert dates?

[Cspen]

The workflow I'm working with has 10 Date Time tools converting the formats to "string to date/time format". Is there an easier way to covert these using less tools? 

[cjaneczko]

You can use a formula or multifield/row formula tool. Take a look at this reference guide on how to properly parse the dates.

https://help.alteryx.com/current/en/designer/functions/datetime-functions.html

[apathetichell]

Datetimeparse('_CurrentField_','yyyy-mm-dd') is your friend here.

[nagakavyasri · Accepted solution]

[Raj]

@Cspen 
yes this can be done in multiple ways
a common way suggested is to use multi field formula 
rest you can use a Batch macro as well
Also, you can use transpose, formula and crosstab tools to achieve the same.

hope this helps.