Sort of Date and Time

Ask the community
, , ,
1

How do you properly sort on a time field in Wix Editor?

I have a repeater that list out a set of activities over a period of days. The collection has a Date field for date and a Time field for time (12 hr format). The Date and Time values are displayed in the repeater with text elements. Below is the portion of code I’m using to sort the dataset and thus the repeater.

$w.onReady(function () {

$w("#textTitleDate").text = memory.getItem("activityDates");
$w("#textEventLocation").text = memory.getItem("eventParks");

let groupName = session.getItem("groupName");

$w('#textGroupName').text = groupName; // page title name for group selected

// sort dataset
$w("#dataset20").setSort(wixData.sort()
    .ascending("date")
    .ascending("time")
);

// set filter
filter();  // custom function to filter dataset

The results in my repeater is correct for date but not for time. It’s listing out time in the following order:

10:30 AM
6:00 PM
9:00 AM

How do I get this to sort in the proper order as per below?

9:00 AM
10:30 AM
6:00 PM