Convert string to date format for multiple field.

Question

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

Change string to date format.xlsx

aatalai · Answer

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

kamal03 · Answer

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

Convert string to date.yxzp

flying008 · Answer

Hi, @SH_94

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

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