Pre-filter list module stripping from the query

thellie

Member
Hi,
I'm setting up some pre-filtered lists for staff to check various things. Most are completed and work correctly - current volunteers, future volunteers, next volunteers...

But this one, which shows the latest arrivals isn't working. I have the pre-filter as:
Code:
AND startdate GREATER OR EQUALS (SELECT MAX(startdate) FROM vol_appform WHERE startdate < NOW()) 'query'
AND startdate LESS THAN OR EQUALS NOW() 'no quotes'
...but it knocks out the '<' each time I save the module.

Any eye deers?
Thanks :)
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top