Problème de conversion de colonne de date dans Looker Studio

Looker Q&A Looker Studio
1

Hello,

I’m facing a recurring issue in Looker Studio: my date column coming from a Google Sheets source is recognized as “Text”, and I’m trying to convert it into a valid date using a calculated field like:

PARSE_DATE(“%d/%m/%Y”, Date DATE)

However, Looker Studio keeps refusing to convert it and shows this error:

“Unable to convert the data to date”

Here’s what I’ve already checked:

  • The column values are correctly formatted as DD/MM/YYYY (e.g., 19/09/2025).

  • I tried different syntaxes (PARSE_DATE, PARSE_DATETIME, TO_DATE), none worked.

  • I recreated the data source and confirmed there are no invisible spaces or formatting issues in the column name.

Despite all this, Looker Studio still treats the field as text and won’t parse it.

This is blocking an important dashboard project — could you please investigate if this is a known bug or help me solve it?

Thank you very much,

Moussa