That should work unless you have a mistake somewhere else.
I have just tested this snippet locally and it all seems to work:
I have just tested this snippet locally and it all seems to work:
PHP Code:
$date = new DateTime('2017-08-31 22:00:01');
$start = $date->getTimestamp();
$date = new DateTime('2017-10-01 23:59:00');
$end = $date->getTimestamp();
$activeItems = $itemMapper->getSimpleItems('active=1');
$resultItems = $itemMapper->getSimpleItems("mydate>=$start && mydate<=$end", 0, 0, $activeItems);
$filteredItems = $itemMapper->filterSimpleItems('mydate', 'ASC', 0 , 0, $resultItems);
Util::preformat($filteredItems);