Skip to main content

Similar to Sheets/Excel functionality, I’m looking to change the display format of a date field, and this being updated by the end user too if desired. The same way that we can change it when grouping by a date field, and how Currency fields can be summarized from the Show Me section.
Eg:

 

Mockup: update display format



I know that for some cases is possible to workaround this limitation by creating an additional calculated fied within the object like Year Number, but there are some that are not possible and even if they were, they wouldn’t achieve the desired sorting because strings do not behave like dates. Consider the Quarter of Renewal Date as example, a string would order by groups of quarter first:  Q1 2025, Q1 2026, Q2 2025, but if only the display format is changed, it would honor chronological ordering:
 






 

 

This idea didn’t pop up when searching, seems that “display” was the missing key word. Here is a more detailed example of the same requirement but expanded to more display formats:

 

Yes please! Wrestling with date formats is a huge time sink every time it comes up.

Terms & ConditionsCookie settingsAccessibility statement