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. Problem making a WPQuery with ACF boolean
  29. Meta_query compare operator explanation
  30. meta_query with meta values as serialize arrays
  31. Nested meta_query with multiple relation keys
  32. meta_query ‘compare’ => ‘IN’ not working
  33. Use REGEXP in WP_Query meta_query key
  34. WP Query Args – Title or Meta Value
  35. Meta query with string starting like pattern
  36. compare meta_query in get_posts arguments
  37. How to query posts based on lat-lng coordinate as post meta?
  38. how to show posts that are missing a meta_value
  39. Set Alias for meta_query arguments in get_posts()
  40. Sorting: custom query with orderby meta_value_num THEN by title
  41. Display List Of Posts Containing a Relationship Field Value [ACF]
  42. Display products from specific category in shop page
  43. Using OR conditions in meta_query for query_posts argument
  44. How to Compare Two Meta Fields
  45. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  46. Does tax_query really beats meta_query in all situations?
  47. WP_Query with checkbox meta_query
  48. Add indexing to meta_value in wp_postmeta
  49. Is it possible to orderby multiple meta_keys when using meta_value_num?
  50. Custom WP_Query order by post_meta and (author) user_meta
  51. Query WooCommerce orders where meta data does not exist
  52. Filtering a WP_Query meta_query by numeric values isn’t working
  53. Getting attachments by meta value
  54. Query Multiple Post types each with own meta query
  55. Execute a large WP_Query with many “AND” Meta_Queries?
  56. Using WP_Query To Get Posts Randomly From today
  57. WordPress Custom Query to show posts from last x years
  58. Query all posts where meta value is empty
  59. WP_Query min and max values
  60. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  61. Using custom meta_query with relation not working as expected
  62. Perform query with meta_value date
  63. querying with custom meta field with meta_query
  64. Order by two meta keys
  65. multiple meta key but get server load is very high
  66. Meta Query with date and time on the same Day before given time
  67. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  68. How to grab metabox value in wp_query meta_query key
  69. WP_Query meta_query where meta value ends in space
  70. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  71. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  72. Nested query inside Logical operator OR not working in meta_query
  73. Is “orderby” in WP Meta Query conflicting with Meta Query?
  74. WordPress meta_query and order by custom field
  75. Query by meta_key and order by meta_value_num return orderby date
  76. What is an efficient way to query based on post_meta?
  77. WP_Query not working as expected for attachments and custom meta_query
  78. How do I create my own nested meta_query using posts_where / posts_join?
  79. How to get the posts published in last two days using WP_Query?
  80. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  81. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  82. Revolution Slider Orderby Two Custom Fields
  83. Compare two meta-fields in a wp_query (where meta-field-A is larger than meta-field-B)
  84. Wp_query order by multiple custom fields?
  85. How can I create a WP_Query that returns posts where one meta_value
  86. Meta Query querrying several post types based on ACF fields is broken after update to WP 4.1
  87. List taxonomy terms plus their latest post ordered by post date
  88. WordPress altering my custom query, How to fix it?
  89. WP Meta Query for some meta (array) values
  90. Exclude post on loop by multiple meta key value
  91. Sort users by meta_value_num
  92. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  93. query posts in functions.php and update a field
  94. How to get sum of meta_values of a meta_key in wp_query according to conditions
  95. How to query ‘posts_per_page’ to display a different blog posts index template?
  96. Order by meta_key in custom post type doesn’t affect the query
  97. How to count data records in wordpress which have same meta_value in wp_postmeta table?
  98. How to create/modfiy WP_Query to search in post title OR custom field?
  99. Using WP Query to search within ALL keys in meta query
  100. Order By Multiple Meta Fields

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)