Hi Folks,
I have a Seat availability App, where users can see the No of office seats occupied in a particular day.
And there I have a small requirement where we have 2 Date Pickers: From Date and To Date; so whatever dates users pick, in the Dropdown Gallery, we must see the the no of seats occupied against the dates.
So if user pick 7 days, gallery should return 7 rows (if he/she picks 10 days, gallery should return 10 days of data) having 2 columns: Date (in Sorted order) and Occupied seats. I can bring the count of occupied seats according to the dates. But how can I bring the Dates in sorted order?

The data is coming from SharePoint Lists.

Kindly help..