Help Please -- STRING to DATE

[SaadEnnassiri]

Hello all, 

I tried to pars this string using the Datetime tool but was not able to find the correct custom input format

2018-11-23T14:30:14.510Z 

Can you please help me with that. thx a lot for your support

[marcusblackhill · Accepted solution]

Hi @SaadEnnassiri !

You can eliminate the letters with the data cleansing and with its not a problem to eliminate the information after the seconds, you can use a regex to replace by nothing and with the new layout you can put the pattern of yout date/time in the tool.

Here I mocked up a workflow to you look what Im saying.

I hope that help you

[szade1 · Accepted solution]

Hi @SaadEnnassiri ,

Here's my approach:

Just removed the milliseconds part of the string and converted to datetime

hope it helps!

Thanks,

S.

[SaadEnnassiri]

Thanks a lot