Issue with the dates (data coming from excel)

Hello,

I am struggling with the dates.

I've imported a data from Excel, with a column date Looker studio sees it as a date (it has the little calendar symbol)

But at the moment that I add the date boton from looker studio, and select any date the data isn't showing anymore

 

Does anyone have any idea please ?

Solved Solved
0 12 3,887
1 ACCEPTED SOLUTION

Hello
I'm sseing that I finally got some answers

I did found the solution
I created a new field

Called New_date

And with that as a formula

TODATE(Date, "%Y-%m-%d", "%Y%m%d")

View solution in original post