Start a new topic

Remove timestamp AND reformat date?

Is this possible? Date/Time is coming down like this:

2017-05-26T11:35:19.000-04:00

So I'd have to remove the timestamp first, correct? Then reformat the date to MM/DD/YYYY. But I can't even get the timestamp removal to work. Any ideas? I'm trying to learn but am not wrapping my head around this. :(


1 person has this question

 It looks like this was never answered? But I am having this problem too. Is there an answer to this?

I've attached a file with the dictionary you can import that will translate 2017-05-26T11:35:19.000-04:00 to 05/26/2017.


The dictionary will look like this:



The first line replaces the T with a space, the second line drops the timestamp, the third line rearranges the remaining date elements.





Amanda

Omatic Support

csv
(127 Bytes)
Login or Signup to post a comment