Data Studio not recognizing date format
We're trying to use data studio with Sheets as a data source and we're having trouble getting some date fields recognized.
We're putting 3 dates (including other data) into a sheet line, all in the same format (ISO 8601), e.g: 2017-03-01T07:56:34.940583+00:00
Now, this works wonderfully with two of the three dates. But the third one is not recognized as a date but rather as a string instead. Here's some screenshots:
How we have the data in Sheets
and how it's shown in Datastudio: