Sorting a Date Time Field

Ask the community
,
1

I have a Clubs page connected to a dynamic club-details collection.
collection = club-details
dataset = #thuDataset
repeater = #thuRepeater
text field = #thuClubTime connected to #thursdays / startDate (Date and Time)
I have filtered my dataset to just show just the clubs on Thursdays, that is working. Now I would like to code the page to sort #thuClubTime (12 hr ) correctly. See below 4:00 .m. is before 10:30 a.m.

Many thanks
Sylvia

942×1388 189 KB

2

I am really lazy. I work in 24 hour time. Have a field where the time has been converted into 24hr and then order by that. 4pm = 1600hrs which is > 1000.

3

ok I guess I would set the database field to 24 hour, then in the page dataset #thuDataset sort it, then in the page code convert it to the 12hr type and pass it to the #thuClubTime .
Thanks Kyle I will give it a try.

4

Or just have an extra field for 24 hour. As said just the way I would do it. Others will probably have a simpler way