Date format issues

Looker Q&A Looker Studio
1

Hello

I have issues to deal with date format. Is there a better way to format dates in Google Sheet so they are identified properly in LookerStudio ? if YYYY-MM-DD a good solution ?

I’ve tried many configurations, always having troubles.

Thanks for the support

2

You would want the column in the Google sheets to be in DateTime format, otherwise it will take it in as a string. Back in looker studio you could change the Formatting to “DD-MM-YYYY” or “MM-DD-YYYY” as per the need.

3

Hey,

Hope you’re keeping well.

Looker Studio works best when date fields are stored in a consistent, ISO 8601 format (YYYY-MM-DD) before importing. In Google Sheets, set the column format to Plain Text and manually enter or use a formula like =TEXT(A1,”yyyy-mm-dd”) to ensure the exact output. Once in Looker Studio, verify that the field type is set to Date in the data source schema so it’s parsed correctly. This avoids locale or formatting issues that can occur with regional date styles.

Thanks and regards,
Taz