Issue with the dates (data coming from excel)

[LeBoss]

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 ?

[DataStudioGuru]

Hi @LeBoss,

Without more context, there could be several things causing this. To make sure I understand: when you added the 'Date range control' and selected a range, the elements on your page show 'No data' (or zero)?

• Are you certain your dataset has rows with dates matching the range you selected?
• Does your report show data when you set the 'Data range control' to: Auto date range?
• It could also be a source issue. Please go to File > Report settings... in the sidebar, please verify the 'Data source' matches the elements in your report. You could also try to delete the source here, see if that fixes things.

If that didn't work, could you please provide a few screenshots of the report in Looker Studio and the data in your sheet?

Thanks

[micpi]

Hi DatastudioGuru 🙂

I think I have the same issue, Honestly, I Prefer to use goodle sheet as a data base, but my file is too big, and update doesn't work, so being able to use Excel is a big big step for me.

I have the same issue with dates fields, I did create a small excel file to test import, and Looker studio recognise as a date format, but when you put it in a report, you have an error message, so I'm unable to do anything (I tried to create dates in "Text", then Import and use parse function, but It still doesn't work)  .

I did put the screen shot of the data base, and the error message, if you can help me (I'm using French Lookerstudio, but I'm not sure this is the reason why it doesn't work).

Thanks for your help 😄

Error Message

[DataStudioGuru]

Hello @micpi @LeBoss,

Thank you for providing more information. I've been able to reproduce the problem and it looks like a bug in the application. I created an issue that you can upvote and track:
Configuration Error when using the Date Range control with the Microsoft Excel connector [360641488]...

Let's hope it gets resolved quickly!

[Kev77]

Just wanted to chime in to say I have essentially the same issue. I was looking forward to using the new Excel connector however it doesn't seem to work with my dataset. My date column is clearly formatted as a date and LookerStudio seems to recognize it. The issue comes when I add a date control. As soon as I do that, all my charts that use the date field throw errors and I can't use the control. I tried a few date formats (MM/DD/YYYY for example doesn't work).

[Monitor]

It could be that the date format is in a different language or format, try to normalize the entire date column with the same format and data type; you can use YYYY-MM-DD or YYY/MM/DD. Whichever you decide to use and all have the same format, add one last trick; run Replace All and replace all the - or / signs, whichever you have chosen.

[absoliute]

I was running into this same issue and tried every iteration trying to adjust the date field or simplifying my data.  The issue is the Excel connector itself.  Just upload your file as a CSV with the regular File Upload data source and that should fix your problem.  

[micpi]

Hi Guys, I just saw that the the Excel connector is no more in a "preview version", but I still have the same issue with the date.

I found a solution on an other forum, if I use the Function TODATE, it seems to work (I'd prefer if it could work automatically and without function but still not, maybe soon), so for me, it is 75% solved.

Have a nice day.

[ZeeVee06]

the TODATE function only returns the values of starting date

[Laurent-N]

Hey Thanks Micpi !

Exactly the tip I was looking for !

🖖

[LeBoss · 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")

[Laurent-N]

Hey Thanks Micpi !

Exactly the tip I was looking for !

🖖

[micpi]

Hi guys, I did more tests, and it finally doesn't work on my side, the new field is considered as a date, but the calculations with other field don't work. 

Maybe I should make another ticket.

Have a nice day.

Michael