DataStudio can't interpret dates properly
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).
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).
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!