So I have a table with fields Title, person, date, startTime and endTime
I am successful in grouping them and sorting by day (thanks to the forum!), however I cannot seem to be able to sort also by startTime per listed note (the sort should be group date - then individual note startTime)
This is the code I use right now
TABLE rows.file.link AS "Class", rows.startTime AS "Start", rows.endTime AS "End", rows.person AS "Person"
SORT date ASC GROUP BY (dateformat(date,"MM") + " | " + dateformat(date,"dd")) AS Day
SORT rows.date ASC