Filtering by date

I'm using event booking and have been trying to filter any old events out by using the filter
event_date > @vdSql:NOW()
but i'm getting a null result. How can I get it to only show future events?

Hello,
Can you please try with the Mysql function enclosed with inverted commas i.e. "@vdSql:NOW()"?

Just seems to ignore the filter now and feeds everything

Please share your backend & FTP login credentials via Contact us form, We'll look into it.

Hello,
I've got the similar problem. In a table there is a column with time format "Y-m-d H:i:s". And if I set column > @vdPhp:date("Y-m-d H:i:s") as a filter it works fine for a future days. But I need a current day in a feed too. I've tried @vdPhp:date("Y-m-d"), the operators "=", "IN", "LIKE", any SQL functions, but nothing works. Don't you know how can I set the filter for a current day (any time in a current day)? Or any function @vdPhp:date("Y-m-d H:i:s") minus one day?

Thanks, Jan

Hello,
It seems the database column is a date-time data type. And you are comparing it with just date format, which won't return the result. You should apply two < > filters with the date followed 00:00 in time and another 23:00.