Using a Looker Studio Scorecard, I am reading in a datetime column shown in a csv file as YYYY-mm-dd hh:mm:ss. In the Scorecard I read in the Max of this datetime column, in order to display the latest date and time, and format it as Date & Time - Custom(MMM dd, YYYY E (h:mm a ‘MST’)). All is good…except that today, 31-Dec-2024, the Scorecard is displaying the year text as 2025. My datetime column does not contain any year 2025 entries so you understand.
So somehow, the Looker Scorecard is reading in the year as 2025 on this last day of 2024. Perhaps Looker is assigning itself to the first timezone out in the Pacific or something odd like this-LoL. Anyways, it is not year 2025 yet. It should instead still show the year 2024 in this case.
