Changing date display format adding a year??

Thanks for the response. I have tried formatting the data in a number of ways but I am still having the same issue.

As an example, if I connect the following to a dashboard:

select
‘2024-12-31’ as raw_date,
date(‘2024-12-31’) as date_date,
PARSE_DATE(‘%Y-%m-%d’, ‘2024-12-31’ ) as parse_date,
FORMAT_DATE(‘%Y-%m-%d’, ‘2024-12-31’) as format_date

I get these results.: