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
Amy Barker
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