Data Studio
1.8K members online now
1.8K members online now
Ask questions about Data Studio
Guide Me

Data Studio not recognizing date format

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi there,


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:


Data studio


Any tips?