[Resolved] Query CPT with date older than today

[Author]

Posts

[camila]

Hello,
I have a custom post type called "Tax Sales" with a custom field called "Tax Sales Date" (it's a date field). I would like to query all posts from that custom post type with a tax sale date that is older than today and from the current year. How can I write that meta query for a date field?

This is what I have currently:
$args = array(
'numberposts' => -1,
'post_type' => 'tax-sales'
);

$post_query = new WP_Query($args);

if($post_query->have_posts() ) :
while( $post_query>have_posts() ) : $post_query->the_post();
/// DO SOMETHING
endwhile;
endif;

thanks

[Luo Yang]

Hello,

You can follow WP document to setup your custom PHP codes:
https://developer.wordpress.org/reference/classes/wp_query/#custom-field-post-meta-parameters

I assume you are using Toolset Types plugin to create the custom date field "Tax Sales Date", if it is, you can try these:

$from = strtotime('first day of january');
$to = strtotime('Today');
$args = array(
	'numberposts' => -1,
	'post_type' => 'tax-sales',
	'meta_query' => array(
		array(
			'key'=> 'wpcf-' . 'tax-sales-date',
			'value' => array( $from, $to ),
			'type'    => 'numeric',
			'compare' => 'BETWEEN',
		)
	)
);

$query = new WP_Query($args);
$res = '';
if($query->have_posts() ) {
	foreach($query->posts as $post){
		echo $post->post_title . '<hr />';
	}
}

for your reference.

[camila]

Hi Luo! Thanks so much , this is great!

I only have another question. What about if I want to get all tax sales older than today??

thanks

[camila]

My issue is resolved now. Thank you!