I see that there is considerable confusion here on this subject. While System Settings (General) does accept and retain the ISO 8601 format (yyyy-mm-dd), and, in fact defaults to that format when Canada is the selected Region (or remembers what I had previously set), something else is in play that forces several applications, Apple and non-Apple, not to respect that chosen format. The developer of one of my apps seemed to find the flaw in Sonoma and republished the app to workaround the flaw.
The best that anyone can do at this point is to submit Feedback to Apple, as I have done explaining that I am holding off my upcoming purchases of new products until Sonoma is cleared up. Sonoma has numerous bugs in other functions as well. One example is that when I select a previously sent email, and edit the content, keyboard input is ignored where old text was deleted. Similar complaints are found on various forums across the Internet.
Sonoma 14.1.1 on an M1 Mac mini. Previous operating systems (prior to Sonoma) work just fine. I regret updating this particular Mac.