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. :(

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