Convert string to date format for multiple field.

[SH_94]

Hi community,

Would like to ask how to make the workflow more dynamic to select multiple field to convert from string to date format as below 

Example

[gawa]

Hi @SH_94 

You can use Multi Field Formula tool when you want to manipulate the multiple field with same formula by a single tool. 

[flying008]

Hi, @SH_94 

FYI.  (Change output type to 'date'.)

DateTimeParse(ToString([_CurrentField_]),'%Y%m%d')

[kamal03]

You can use the regex_replace function to change the string into a date.

[aatalai]

you could use the transpose tool to get the data in one coloumn and then use datetime tool / formula with datetime parse and then cross tab tool. If you don't want to use regex