Topic-icon Filtering by date

More
09 Jul 2018 13:17 #6130

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

More
09 Jul 2018 11:23 #6128

Hello,
I setted up

> @vdPhp:date("Y-m-d 00:00:00")
and this works fine.

Thanks, Jan

Please Log in or Create an account to join the conversation.

More
28 Jun 2018 09:04 #6099

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.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

More
26 Jun 2018 13:29 #6093

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 Log in or Create an account to join the conversation.

More
21 Jun 2018 13:13 #6082

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Ted
  • Ted's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
20 Jun 2018 22:57 #6079

Just seems to ignore the filter now and feeds everything

Please Log in or Create an account to join the conversation.

More
11 Jun 2018 11:32 #6053

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Ted
  • Ted's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
09 Jun 2018 00:00 #6050

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?

Please Log in or Create an account to join the conversation.

Cron Job Starts