Current date as meta value

I think I have the same question. My meta key is end_date for an event. I want to query only the events, which are in the future.

I am trying to use “current_time(‘Ymd’) as a meta value and compare “>=”, but I don’t get any results.

Why?

Same here. Sorry to jump in here.

I also have ACF date field and want to show all posts that are “>=” than the current date. Could you solve the problem to compare the current date?

I discovered two problems for me: neither the ACF meta_key nor the meta_value were being inserted into the query.

It appears that ACF is not registering the custom fields as post meta. I had to write a simple function to do that. Perhaps you might not have this problem.

I am fine with that but the next part is kinda ugly. I added one line of code to the AQL plugin file query-loop.php. This is not ideal or recommended as any updates to the plugin may overwrite, requiring the line of code to be re-added or no longer work. Inside the foreach loop on line 23 I added:

if ( $query['meta_value'] == "todays_date" ) { $query['meta_value'] = date( 'Ymd' ); };

Then, in the query loop block settings I put “todays_date” as the meta_value.

This works, but is not “proper”. And I’m sure the plugin author will have a much better way to do it.

UPDATE: After updating to 1.4.1, I re-added same line of code and it still works.

Thanks Lane.

It would be nice if something like this could be done without hacking. I find the plugin great and very useful, but that is currently probably the limit.

During my research on how to change the query loop, I came across this website and the AQL plugin was introduced at the End oft the following article. I have now done it according to this tutorial.
https://wpfieldwork.com/modify-query-loop-block-to-filter-by-custom-field/#block-variations