How do I convert this string datetime to datetime format?

[kelvenlim]

I got this table after using the Download and JSON Parse tools. Currently, the datetime shown is in string. I tried using the Select tool to change the data type to datetime, but it didn't work because the values have unnecessary characters.

Is there a way to remove those unnecessary characters and convert the string to datatime?

Thanks.

[ShankerV · Accepted solution]

Hi @kelvenlim 

One way of doing this!!!

Many thanks

Shanker V

[ShankerV]

Hi @kelvenlim 

The solution can be achieved in one tool also as below.

Usually we will use Formula tool to apply our formula to work.

That can be applied to only one column, but we have 3 columns to be applied with same formula.

Hence MultiField Formula is used to apply the same formula to one or more columns.

Many thanks

Shanker V

[kelvenlim]

Thanks @ShankerV!! It works now