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.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
ACF wouldn’t be so widely used in WordPress if it didn’t have some pretty amazing capabilities. In this article, we look at a few of the features we’ll discuss during “7 things you didn’t know you could do with ACF” at #WPEDecode later this month. https://t.co/5lnsTxp81j pic.twitter.com/Yf0ThPG1QG— Advanced Custom Fields (@wp_acf) March 16, 2023
© 2023 Advanced Custom Fields.