I have a functioning database using the calendar and all is well. However, when looking at a "View" on a Page, the default date format is, for example: 4 July 2026. The view can be sorted in date order perfectly, but if I change the view (column display) to show 04 Jul 2026 using format(Mydate,"DD MMM YYYY", the resulting sorted order relates to a sort of the TEXT VALUE (all 01's then all 02's etc), not the date value..

How can I maintain the sorted order but change the visual presentation of the date in a view column? Maybe I'm missing a setting for "default date presentation" somewhere!?

Platform: MacOS App - latest version.

Thank you.