0

It seems Looker studio had a bit of an update and ever since I can't get my dates to work.
My excel file saves a .csv with dates formatted as YYYY-MM-DD
Screenshot showing formatted date rows

and uploads it using CSV file upload.

When connected, it's saving the data as text and when I try to change to the date format I get this error

"Can't convert to date

Looker Studio can't convert Date (Text) to a Date or Date & Time because it doesn't recognize the date format.

Possible solutions:

  • Change your data to use a supported format

  • Create a calculated field to convert Date to a valid date. For example, to convert "202011" to a date consisting of year and month:
    Example: PARSE_DATE("%Y%m", Date)"

I can change it to the Date & Time option but this doesn't seem to work for my date sensitive graphs.

Has anyone come across this recently? It used to work perfectly fine this way.

Improve this question
New contributor
LOK is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
1
Related questions
0
Google Workspace, BigQuery and Looker/Data Studio
0
Can time series settings in Google Data Studio change depending on date format?
1
Date formatting from BigQuery to Data Studio
Load 5 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.