Google Looker Scorecard Date Year Bug (Reverts to Current Year)

Looker Q&A Looker Studio
1

When adding in a Google Looker Scorecard, with a primary Datetime field, and setting it to Max to determine the latest date, Looker adds in the current year to the date instead of the last year. For example, I have a data file and set its Default date range filter to Custom to: Jan 1, 2024 - Dec 31, 2024. The output of the Scorecard finds the latest date time, but states like “Dec 31, 2025 Tue (7:02PM)” instead of the correct “Dec 31, 2024 Tue (7:02PM)”. So it’s not getting the correct year in this case, which would is 2024.

2

Hi @redgreen1889 ,

Try this workaround:

  • Apply a custom SQL or calculated field to explicitly extract the year.

  • Double-check that your data source date fields are correctly typed (not strings) and your date range filter is applied at the right level.

If the issue persists, I recommend reporting it via Looker Studio feedback — Google’s team tracks these bugs.