Hi,
i have a problem that drives me crazy.
In a project i have pages (template concert) with a DateTime Field "date_time" (output is "d.m.Y" for date and "H:i" for time, "d.m.Y H:i" for date and time).
When i use this selector:
$items = $pages->find('template=concert,sort=date_time,date_time>=today');
i get all the concerts in the right order by date. But inside a date, the concerts are not ordered by time. It looks like a random order to me.
As far as i know, the datetime field uses a timestamp. So why is the order wrong? Why are the items only ordered by date?
Is that a bug or am i missing somehing? I've spent nearly hours to seach for this topic, read documentation of selectors, the cheatsheet and even looked inside the datetimefieldtype code but could not find a solution.