Query Post Type and Repeater field =>Sub Field date

• Tony B

• December 12, 2019 at 9:35 pm

Hello,

I done a query width sub field repeater date.
My query works perfectly, but in the meta query date (subfield), he don’t want to show result width = in the compare.

I am looking for the good pratice ta have only results when the meta query is = only today. Is it a format date problème ?

When i tried it this meta query like it (he don’t work):
array(
‘key’ => ‘commentaires_$_date_de_rappel’,
‘compare’ => ‘=’,
‘value’ => $date,
),

My Query :
$date = date(‘dmY’);
$yesterday = date(‘dmY’,strtotime($date1 . “-1 days”));
// args
$args = array(
‘numberposts’ => -1,
‘post_type’ => ‘entreprise’,
‘meta_query’ => array(
array(
‘key’ => ‘commentaires_$_date_de_rappel’,
‘compare’ => ‘>=’,
‘value’ => $yesterday,
),
array(
‘key’ => ‘commentaires_$_date_de_rappel’,
‘compare’ => ‘>=’,
‘value’ => $date,
),
array(
‘key’ => ‘commentaires_$_date_de_rappel’,
‘compare’ => ‘NOT IN’,
‘value’ => ”,
),
)
);

$query99 = new WP_Query( $args );
if ( $query99->have_posts() ) {
while ( $query99->have_posts() ) {
}
}
wp_reset_postdata();

Thank you for your help. I will be apprecied !

• John Huebner

• December 13, 2019 at 12:08 am

$date = date('Ymd');

• Tony B

• December 13, 2019 at 12:15 am

Thank you so much Jhon … It’s work !