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

DataStudio can't interpret dates properly

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

Hello everyone!
Hope you can help: 

 

Im building reports connecting mysql database (from sugar CRM) with datastudio. I found out that some dates cannot be interpreted properly. In fact can only select 2 dimensions for dates dimensions (which are date_entered and date_modified). 

 

download.png

 

But I have other dates as dimensions (like dt_iscrizione), which seems to be formatted differently. Please see screenshot below. Dates are 2017-05-24 (the one that is not read from datastudio as date) and 24 mag 2017 (which is properly read and i can use as dimension). 

 

download (1).png


Do you have any idea on how i can force datastudio to consider dt_iscrizione as date , and have it as dimension in my reports? 

 

thanks a lot for your help!
eugenio

DataStudio can't interpret dates properly

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

I think I fixed it.. i just changed the field (dimension) from Text to Date in the overview of the fields to import for the reports. 

hope this can help others Smiley Happy 

DataStudio can't interpret dates properly

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Do both of your fields in data source have type Date (YYYYMMDD)?