I have a Date/Time field with a FROM and TO date/time, Time Format set to HH:MM am. I might have 9/21/2026 11:00am to 9/22/2026 8:00am OR 9/19/2026 9:00am to 1:00pm. I want the user interface to be AM/PM, not 24 hour format.
Sorting by the Date/Time presents 11:00 AM before 9:00 AM because the “1” comes before the “9”. How do I get the sort to work properly without changing to 24 hours? What am I missing? I’ve done a bit of coding for this but I figure there has got to be a better way.
ONE Alternative : I used a formula field to extract the first 18 characters of the Date/Time to get the Start Date/Time, created a second date time field to the extract (condition) and set THAT field to 24 hours, and sorted by that field. It seems a lot of work to do something simple.
Thank you for your consideration.
Karen
