Late to the game but I have spent hours trying to fix this issue. Turned out it was a c# issue picking up the system date format. The system had been set to show the day of the week as in "Sunday 01/26/2025" in the task bar. When this was uploaded to SQL as part of some C# upload service it was causing SQL to throw this error. Setting the date format on the server to not include the day was the quick simple fix. Long term c# code needs updating to not take the system format which I assume must be the default.