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
Solved! Go to 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
Hi @SaadEnnassiri ,
Here's my approach:
Just removed the milliseconds part of the string and converted to datetime
hope it helps!
Thanks,
S.
Thanks a lot