Forums

Filter settings: now()

neotrend 17 Apr, 2018
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.
Max_admin 19 Apr, 2018
Answer
Hello neotrend,

Please try:
Article.publish_down/>=:{date:Y-m-d H:i:s}
Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.