How so I get a report to sort in order of date?

amy_ilearning

This may just be a vent, but I have a report that pulls from about 15 different sheets with archived data from 2024 and 2023. I want the most recent submissions to show first. When I sort the report by the Date/Time column by descending order, it doesn't work. It'll start with 1/1/24 first and work through today (3/22/24). Then it will start with 1/1/23 and work through 12/31/23.

Why does it do this? How do I get the report to show today's date first and descend from there?

Paul Newcome

Are you able to provide some screenshots for context?