wp query – WPQuery Date and ACF

Question

I’m creating a Query, and i need to filter by an ACF date field.
In the database the value (in wp_post_meta table) is like this : MM/DD/YYYY

I have few rooms with, as a value in the field date_available_from, this :

  • 06/01/2021
  • 08/21/2021
  • 08/31/2021
  • 09/06/2021
  • 07/30/2022
  • 10/31/2021
  • 11/31/2021
  • 12/31/2021
  • 01/31/2022
  • 03/10/2022

And then i do my query like this :

$args[1] = array(
'posts_per_page' => -1,
'tax_query' => array(
    array(
        'taxonomy' => 'cities',
        'field'    => 'slug',
        'terms'    => $term_slug,
    ),
),
'post_type' => 'room',
'meta_query' => array(
    'relation' => 'AND',
    'date_available_clause' => array(
        'key' => 'date_available_from',
        'value' => $date_from_format_search,
        'compare' => '<=',
    ),
),
'orderby' => array(
'date_available_clause' => 'ASC',
)
);

Problem 1 : The clause doesn’t works

ex : date_available_from <= 07/19/2021 give me :

  • 01/31/2022
  • 03/11/2022
  • 06/01/2021

date_available_from >= 07/19/2021 give me :

  • 07/30/2022
  • 08/31/2021
  • 09/06/2021
  • 10/01/2021
  • 10/31/2021
  • 11/30/2021
  • 12/31/2021

And my sort, is always by month (not by date)

How can i edit my code than let the filter and sort alright ?

Thanks

0
djoo 3 months 2021-07-19T12:33:22-05:00 0 Answers 0 views 0

Leave an answer

Browse
Browse