Filtering by date

Hello,
I'm glad, you got it working. In case of any further queries, please let us know...

Hello,
I setted up and this works fine.

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.

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

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

Just seems to ignore the filter now and feeds everything

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

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?