Home Forums General Issues WPQuery Date and ACF Reply To: WPQuery Date and ACF

  • So, at the end of all i followed a bit of all the advises i found online.

    First, I changed the value of my fields to make sure in database is like YYYYMMMDD. The problem i had was, that the field was filled up through API and ACF could not format the date at the good format in database. I have to changed the format of the date that i send through the API. Normal people using the backend to fill up the field date would never have this problem.

    Second, i add a line in my code

    ‘date_disponible_clause’ => array(
    ‘key’ => ‘date_available_from’,
    ‘value’ => $date_from_format_search,
    ‘compare’ => ‘<=’,
    ‘type’ => ‘DATE’ // This line
    Now it’s working very well. Thanks.