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:
...but it knocks out the '<' each time I save the module.
Any eye deers?
Thanks
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'
Any eye deers?
Thanks