Now()

[aldan]

hi,

I want to filter an events table (sorry, list...) to show events with the date equal or greater than NOW(). Everything looks ok in the prefilter section, still it won't show events of Today- only starting with tomorrow. Type is set to "no quotes", but I can change it to anything, same result.

server time is set globally in joomla to my time zone.

what am I missing??

thanks
alex

 

[troester]

Now() is now (including the time), maybe your dates are 2012-12-17 00:00?
Try with curdate()

 

[aldan]

hmm... thank you for the tip.
apparently my problem is of a different type, because I disabled all pre-filters, it should show the whole table, but it doesn't... still shows events in the future.
could it be some filter lingering on the server somehow?

 

[aldan]

geez!... I had the same filters doubled in the menu item definition...

ok, so problem solved, curdate() works, thank you

alex