Hi, i put a where clause (if startdate is bigger than date-now) in my migxdb-cmp it does not compute.
But putting it on a frontend snippet like migxloopcollection i get the designated result:
[[!migxLoopCollection?
&packageName=`alldates`
&classname=`EventDates`
&where=`{"startdate:>=":"[[!today]]"}`
&tpl=`go`]]
where "today" is a snippet : return date('Y-m-d 00:00:00');
is outputting, as expected only future startdates. How to do this within the actual CMP?
Cheers, Michiel