After installing the October 2024 Cumulative Update (or any subsequent update) for SharePoint Server Subscription Edition, the Date column values in lists may incorrectly display as December 30th, 1899, instead of the correct date, under the following conditions:
- The site locale uses a date format where the day precedes the month (e.g., DD.MM.YYYY or DD/MM/YYYY).
- The day value of the date is greater than 12 (e.g., December 14th, 2024).
- The list contains at least one column with custom formatting enabled using JSON (this column does not need to be the Date column)
The issue is currently being investigated.
Example
List on a site with german locale and custom formatting for the Title column.
Before October 2024 CU:
After October 2024 CU:
Workarounds
There are two possible workarounds:
- Change the site locale to a locale with MM/DD/YYYY format. E.g. English-US.
- Remove custom formatting from all columns in the list
Permalink
If it weren’t for you, who would help us? Thank goodness you exist. I miss your full technical blog posts. You, Josh Roark, and the other heroes which we don’t know their names. Thanks you again. Long live SharePoint Brotherhood!
Permalink
Thanks Hasan! 🙂
Permalink
Hi,
totally agree with Hasan Köroğlu. I think too little attention is given to SharePoint on-prem.
Permalink
Totally agree!! Respect for all that you do and communicate. Same goes for the whole SP team.