Start a new topic

Remove timestamp AND reformat date?

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


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

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.


Omatic Support

(127 Bytes)

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

Login or Signup to post a comment