AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4K members online now
4K 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