"Weird" date format: how to handle it?
I get data from a JSON feed that has a date format that I can't make it work with Zoho Analytics.
- 2018-11-28T14:34:07-02:00
I tried the format:
yyyy-MM-ddTHH:mm:ssZ and it won't accept because of that "T". If I do not put the "T" it gives an error.
yyyy-MM-dd HH:mm:ssZ.
It works if I only get the dates, but not the hours:
yyyy-MM-dd.