ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format

There should not be any need to do this.

Even if an ACF Field is using 'return_format' => 'm/d/Y g:i a',

The post_meta value is in YYYY-MM-DD 00:00:00 format.

$date_now = date('Y-m-d');
$args = [
  'meta_key'=>'the_date',
  'meta_value'=>$date_now.' 00:00:00',
  'meta_compare'=>'>=',
];
$query = new WP_Query( $args );

Edit: I’ve noticed some discrepancies in this, the value may be in Ymd. When in doubt, check the data. You can find the post_meta by looking up the post_id in the wp_postmeta table.

Related Posts:

  1. ACF Relationship Field Search Filtering [closed]
  2. datetime picker, timestamps and meta queries
  3. meta_query with array as value
  4. Use meta_query to display events by date in custom field
  5. If two first numbers exist in wp_meta_query value
  6. WP_Query meta_query >= date
  7. ACF Date Based wp_query
  8. Custom query based on meta key – Reduce three states to two in results?
  9. What is the random string I am seeing when I use get_query_var?
  10. Any number in meta key (wp query)
  11. 2 weeks ago from meta query meta value
  12. WP_Query with meta_query dosen’t return results
  13. Custom query filter by ACF date custom field
  14. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  15. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  16. WP_Query, ACF field and array
  17. Pre get posts sort by meta key returns no results if meta key does not exist
  18. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  19. datetime picker, timestamps and meta queries
  20. Get posts meta_query by repater field
  21. How can I modify standard search query to include also ACF custom fields values?
  22. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  23. Get posts using multiple values from ACF checkbox as meta query wordpress
  24. How do I subquery with custom meta fields?
  25. Use value from meta key array for use in WP_Query
  26. WP Query Args – Title or Meta Value
  27. Meta query with string starting like pattern
  28. Does tax_query really beats meta_query in all situations?
  29. Query WooCommerce orders where meta data does not exist
  30. Execute a large WP_Query with many “AND” Meta_Queries?
  31. Using WP_Query To Get Posts Randomly From today
  32. Query all posts where meta value is empty
  33. WP_Query min and max values
  34. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  35. querying with custom meta field with meta_query
  36. Order by two meta keys
  37. multiple meta key but get server load is very high
  38. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  39. Wp_query order by multiple custom fields?
  40. Minimising number of queries on a page when using Advanced Custom Fields
  41. How to show recent and upcoming birthdays using meta_query
  42. ACF Relationship + WP Template Parts
  43. Using WP_Query and WP_Meta_Query Outside of WordPress
  44. WP_Query on custom field and order results
  45. How To Fix WP Query Returns Results But Shouldn’t?
  46. Tax query clause inside a meta query clause?
  47. Include custom field in Ajax search WordPress
  48. Optional Meta Query
  49. How do I make a meta_query OR relation work? [closed]
  50. Elementor custom Query with ACF fields to show matching woocommerce products custom fields
  51. Meta_query on same meta key, with diffrenct values
  52. Can we return all category (not post) with Custom Query Filter? [closed]
  53. Extend product search with meta in WooCommerce
  54. how to make members list directory through wordpress post custom meta key.
  55. Array as ‘key’ in WP_Query
  56. How to provide meta_key array to wp_query?
  57. Searching for meta_key returns 0 posts
  58. ACF accessing a field from the query, but not in post
  59. How to set up hierarchical relationships without using plugins / meta query
  60. Meta query compare for ID’s greater than specific ID
  61. Is it possible to add relation between meta_query and tax_query?
  62. Get a list of ACF Repeater-Fields as array
  63. Show single posts date, in a page of posts
  64. WP_Query Class custom field parameters
  65. meta_query where the meta value is not the post title
  66. Multi-layered WP_Query
  67. Oxygen Repeater Advanced Query
  68. WP_Query for distinct meta values
  69. Group Product Types
  70. How do i create a custom post query when the meta value is an array?
  71. WPQuery Date and ACF
  72. meta_query with meta values as serialize arrays
  73. Woocommerce Get Orders By Meta Value
  74. meta_query is overriding default search
  75. Multiple WP_Query args combinations according to post type
  76. WP Query by variable custom field
  77. WP_Query multiple value not working
  78. How to do WP_User_Query for Nested Array value Inside Nested Array field
  79. WP_User_Query Orderby Not Working
  80. Unusual high query of user meta data
  81. Very slow query generated getting meta data from posts
  82. WordPress Query optimaization for slow query
  83. How to query wordpress with array of meta_values?
  84. Limit default Search query to post_title
  85. Meta query doesn’t remove placeholder escape before query
  86. WP Query Meta Query
  87. Query custom meta value – post view and date meta
  88. Custom WP_query and integrating into theme file
  89. WP_Query – show posts where meta value and user_email match
  90. Best way to Order Post in Home without a plugin
  91. WP_Query using meta_query with LIKE doesn’t return what it should
  92. Return a single custom post from multiple meta queries
  93. query post based on comparison
  94. Including ‘cat’ => $cat breaks meta_query
  95. Query string form $_GET[‘value’] is not working as meta value in wp_query
  96. WP_Query orderby not working on custom post_type
  97. 294 Queries on Mainpage of WordPress
  98. How to get all post_id and meta_value using meta_key in wp_postmeta table
  99. WP Query – Show custom posts only if user contain some user meta
  100. Showing Counts on Comment List with Custom Query

Leave a Comment