Bricks Version: 1.4.0.2 Browser: Firefox OS: Windows
NOTE: Please ignore this if already reported as I couldn’t find a bug report for this.
I have an ACF Datepicker field that I wanted to refer in the query loop’s meta value compare filter. To get posts where the ‘date’ value is in the ‘future’, I set compare to ‘Greater or equal to’ and in the meta value tried using {current_date}, {echo date()} along with the date format that is chosen in ACF fields, i.e. F j, Y. but it didn’t work.
What worked, and maybe strangely the only solution, was to add in the meta value {echo date(Ymd)}as suggested here in the forums.
As far as I know, mysql can’t compare all date formats (if someone knows more, I’m happy to learn). Have a look at this thread, we had this topic already:
I tried that but didn’t work. The only solution so far is what I linked to in the OP, i.e. {echo date(Ymd)}.
And PHP is flexible enough to accept other date formats in meta value. Infact ACF should have returned an error with the "Ymd’ format as ‘F j, Y’ was the chosen output format for the Datepicker. Anyway, please see if you guys could fix it, until t hen Ymd is the only cure.