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. How to use meta_query to retrieve posts from multiple custom post type
  27. WP_Query filtering in ACF field containing dates
  28. Meta_query compare operator explanation
  29. meta_query ‘compare’ => ‘IN’ not working
  30. Sorting: custom query with orderby meta_value_num THEN by title
  31. Display List Of Posts Containing a Relationship Field Value [ACF]
  32. Using OR conditions in meta_query for query_posts argument
  33. WP_Query with checkbox meta_query
  34. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  35. Is “orderby” in WP Meta Query conflicting with Meta Query?
  36. WordPress meta_query and order by custom field
  37. How to get the posts published in last two days using WP_Query?
  38. WP Meta Query for some meta (array) values
  39. Sort users by meta_value_num
  40. Using WP Query to search within ALL keys in meta query
  41. WP Query – Get WooCommerce Products with variation that is in stock
  42. Meta_query with or without value
  43. Meta query field order together with post_date order causes posts without the meta field to be unordered
  44. Undefined property: WP_Query::$post
  45. wp_query not searching with apostrophe
  46. Extending woocommerce admin product search
  47. Performance when getting post meta for post retrieved by meta value
  48. Query by multiple meta elements not seeming to work – wordpress is timing out
  49. How to display multiple custom fields with the same meta_key in an ascending order?
  50. Meta_query with multiple keys and multiple values
  51. How does one perform a sub query with different post types
  52. How to Union two different conditions in one WP_Query
  53. Tax query AND/OR meta query [duplicate]
  54. Help ordering Post loop by two meta values
  55. Multisite wp_query & switch_to_blog issue
  56. Stuck in the query loop
  57. Posts published last 10 minutes
  58. Make meta query treat meta_value as 1 or 0
  59. WP Query Meta Value – How To Identify Specific, Unique Values?
  60. Order by meta_key doesn’t work
  61. Appending to existing WP_Query’s meta_query if exists
  62. Multiple meta_key ordering with pre_get_posts
  63. Query posts using less than
  64. Meta query with compare by more than 2 fields
  65. How to get current page nearest parent id?
  66. WP_Query meta compare must include ALL array values
  67. meta_query returning excluded result
  68. WP Query orderby ACF boolean values and ACF field value
  69. Optimising WP_Query with ACF Fields
  70. meta_query weird behaviour, static int will work, but not user data
  71. Creating a query that get all posts but places meta items first
  72. get_posts query is taking about 40 seconds to execute
  73. wp query to use both author id and meta_query
  74. Excluding posts from search results page with meta query not working
  75. WP_Query for a taxonomy value OR a custom post type meta field
  76. Query for getting posts with their custom fields data in WordPress
  77. Meta query orderby meta_value_num sorting by role first
  78. How to rearrange posts based on input field values added by WordPress “Advanced Custom Fields”
  79. WP Query with meta queries
  80. Get posts having meta value between two numbers
  81. How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
  82. ACF: using two loops, the_field returns field content from another loop
  83. meta_query is not allowing to show posts when querying multiple arguments in a WP_Query
  84. Speed up WP_query with meta comparing dates
  85. Meta Query if Values Don’t Exist
  86. How to show all the associated posts with specific date of data metabox?
  87. Object of class WP_Query could not be converted to int inside shortcode
  88. WP_Query returns empty if meta_query has more than 7 values
  89. Is it possible to search for a string in posts OR postmeta?
  90. WP_Query Posts by Metadata from Option Tree
  91. WP_Query within save_post doesn’t include the item that triggered the action?
  92. Using orderby with 2 meta keys
  93. Why is WP_Query’s meta_query not filtering results?
  94. Display all custom meta field values from the database using ACF Repeater
  95. meta_query in wp_query not working as expected
  96. WordPress extremely slow when using get_posts with multiple meta_query relations
  97. I want to place a post before all others from an ACF boleen field
  98. WP_Query filter Posts by timestamp event (range start and end) and by month (next 12 month)
  99. WordPress – Optimize the Meta Query for 3 meta keys at a time
  100. Include custom post type that matches taxonomy field in another custom post type

Leave a Comment