I am using the live value "now" to search for everything that is from now and future but it does not work. + 1day works but doesn't do what I exactly need.
"today" and "NOW" does not work either - can anyone confirm the issue? How to fix it?
Are you using a Calendar JForm field for the “now” date? I had the same issue and found “now” works if you use the Calendar Picker field instead. Which is a shame as it’s not as attractive as the JForm version. Not sure what the difference is.
yes I am using JForm field - but the strange thing is that it worked in the past. there was a difference between those fields - one worked with today and the other with now but now nothing works...
I'm no coder, but I can't see any difference between the JForm and the Calendar Picker field types. Both use datetime storage in the SQL tables and according to all the research I've done on JForm it should accept "now" as a default value. I've even looked at the PHP file in libraries/joomla/forms/fields but nothing jumps out (perhaps not surprising as I don't understand much about PHP!). Sorry.