Custom query filter by ACF date custom field

Probably the date format should be different – like:

        $date_debut = date('Y-m-d',$date_debut);
        $date_fin = date('Y-m-d',$date_fin);

I haven’t tested this but the doc says:

The ‘type’ DATE works with the ‘compare’ value BETWEEN only if the
date is stored at the format YYYY-MM-DD and tested with this format.

Related Posts:

  1. ACF Relationship Field Search Filtering [closed]
  2. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  3. meta_query with array as value
  4. If two first numbers exist in wp_meta_query value
  5. WP_Query meta_query >= date
  6. ACF Date Based wp_query
  7. Custom query based on meta key – Reduce three states to two in results?
  8. What is the random string I am seeing when I use get_query_var?
  9. Any number in meta key (wp query)
  10. WP_Query with meta_query dosen’t return results
  11. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  12. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  13. WP_Query, ACF field and array
  14. Pre get posts sort by meta key returns no results if meta key does not exist
  15. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  16. Get posts meta_query by repater field
  17. How can I modify standard search query to include also ACF custom fields values?
  18. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  19. Get posts using multiple values from ACF checkbox as meta query wordpress
  20. How do I subquery with custom meta fields?
  21. Use value from meta key array for use in WP_Query
  22. How to use meta_query to retrieve posts from multiple custom post type
  23. WP_Query filtering in ACF field containing dates
  24. Meta query with string starting like pattern
  25. compare meta_query in get_posts arguments
  26. how to show posts that are missing a meta_value
  27. Display products from specific category in shop page
  28. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  29. querying with custom meta field with meta_query
  30. Order by two meta keys
  31. multiple meta key but get server load is very high
  32. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  33. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  34. Query by meta_key and order by meta_value_num return orderby date
  35. Wp_query order by multiple custom fields?
  36. Order by meta_key in custom post type doesn’t affect the query
  37. Use meta_query to display events by date in custom field
  38. Minimising number of queries on a page when using Advanced Custom Fields
  39. How to show recent and upcoming birthdays using meta_query
  40. Multiple meta queries but arrange by specific meta value order
  41. Order Posts by meta value AND published date
  42. ACF Relationship + WP Template Parts
  43. Using WP_Query and WP_Meta_Query Outside of WordPress
  44. ACF – Get lowest & highest value from field
  45. What format does the meta_query TIME type require?
  46. WP_Query on custom field and order results
  47. pre_get_posts order by not working
  48. How to query a custom post type with a taxonomy filter but display post type archive page?
  49. WP_Query filter and order by meta ordering by wrong joined table
  50. WP_Query last five posts, simply ordered by meta_value
  51. How To Fix WP Query Returns Results But Shouldn’t?
  52. Tax query clause inside a meta query clause?
  53. Include custom field in Ajax search WordPress
  54. Optional Meta Query
  55. How do I make a meta_query OR relation work? [closed]
  56. Elementor custom Query with ACF fields to show matching woocommerce products custom fields
  57. meta_query in WP_Query value is not accepting array
  58. Meta_query on same meta key, with diffrenct values
  59. Can we return all category (not post) with Custom Query Filter? [closed]
  60. Extend product search with meta in WooCommerce
  61. Is there a way to work with a specific the_field from an already queried post? [closed]
  62. how to make members list directory through wordpress post custom meta key.
  63. Changing sort order for presentation by Jetpack infinite scroll
  64. get posts by meta_key from inside key of post meta
  65. Help optimizing slow WP_Query with meta_query
  66. Meta Queries – should nesting work after WP 4.1?
  67. Filter and Order by Multiple Custom Meta Values
  68. Meta Query relation “AND” then set array accordingly
  69. 2 weeks ago from meta query meta value
  70. How to provide meta_key array to wp_query?
  71. How to set up hierarchical relationships without using plugins / meta query
  72. Meta query compare for ID’s greater than specific ID
  73. Is it possible to add relation between meta_query and tax_query?
  74. add_query_arg to compare and display events from a certain date
  75. WordPress dynamic AJAX query
  76. WP_Query not returning correct result with meta_query parameter
  77. Query on meta values and post title
  78. How do i create a custom post query when the meta value is an array?
  79. Custom Meta Query doesn’t work the same on two site
  80. WP Query – grouping posts by same meta key, adding together values from another key
  81. How to do WP_User_Query for Nested Array value Inside Nested Array field
  82. Query for current post
  83. Custom query to retrieve oldest post and retrieve others with date interval
  84. Why does my output of get_the_ID() change after a wp_query?
  85. Very slow query generated getting meta data from posts
  86. How to filter on placeholder image
  87. Limit default Search query to post_title
  88. What is the best way to reset a search on a meta_key / meta_value?
  89. Slow query when selecting with large meta query or post__in
  90. WP Meta Query at depth 2
  91. Is there any difference between below WP_Query code snippets?
  92. Geo location query inside wp_query?
  93. Sorting: custom query with orderby meta_value_num THEN by title
  94. meta_query compare not doing what I want it to do
  95. Can’t figure out query logic
  96. WP_Query orderby not working on custom post_type
  97. How do I have multiple metaqueries inside one wordpress query
  98. WP query with multiple custom meta not respecting orderby
  99. Display only posts with thumbnails
  100. Passing a variable containing a comma separated list of values in a meta-query