Buy Now
Sign in

Filter settings: now()

neotrend , April 17 at 19:52
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!