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

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

 

Sheet

and how it's shown in Datastudio:

 

Data studio

 

Any tips?

 

Thanks,

Kim