Buy Now
Sign in

Filter settings: now()

neotrend , April 17 2018
Answered
N
neotrend
I read items from my table and I have a value called publish_down. I now want to have the filtering setting, that only the items before the publish_down value are returned.
In function Read Data, I have inserted in the Where conditions:
 Article.publish_down/>=:now()
it doesn't work because the sql statement looks like:
 WHERE `Article`.`publish_down` >= 'now()'
and I need it without '', means the output should be like:
 WHERE `Article`.`publish_down` >= now()
Thank you for help.
admin
Hello neotrend,
Please try:
Article.publish_down/>=:{date:Y-m-d H:i:s}
Best regards
Max
If your main question got answered then please mark the answer using the button!
Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!