(2017-09-19, 23:31:33)Bigin Wrote: That should work unless you have a mistake somewhere else.
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);
I am thoroughly tested and still not worked. ItemManager v 2.4.0 from http://get-simple.info/
$activeItems -> return all items when active=1
$resultItems -> return all items between 2 dates but ignore $activeItems, (return all active=1 and active=0 items)
$filteredItems -> worked fine
but I try ItemManager v 2.4.0 from https://github.com/bigin/ItemManager_2.0
All worked fine

Please compare this version.
Thanks