I would like to specify the date format for a new date field in my CMS page form. I have created a new cms_page_form.xml field which links to a date field in the MySQL database table cms_page. However, MySQL rejects the field because it is in the wrong format. I have tried setting the format in many different ways: https://i.stack.imgur.com/2TjJ6.png (also without the item options array), literally spending hours trying to set it in cms_page_form.xml with the official documentation for the Date component not providing much of any help: https://devdocs.magento.com/guides/v2.4/ui_comp_guide/components/ui-date.html
Here is my cms_page_form.xml with the date formatting not working: https://i.stack.imgur.com/2TjJ6.png
When I load the CMS page, by default, it displays "Invalid date": https://i.stack.imgur.com/vYxj9.png then quickly changes over to today's date - in the wrong format: https://i.stack.imgur.com/x5zj4.png
All I want is a date input with the format of yyyy-MM-dd in my CMS page form in Magento 2.4.2
If anyone could help me with this I would really appreciate it.