Hide posts if custom field date is less than current date?

• deset

• December 3, 2013 at 7:55 am

Hello,

I am creating a custom post type archive to display a list of training courses sorted by a custom field “course_start” (date picker – yymmdd) and by the “course_type” which is “2 Day TEFL Fast-Track Course”. The custom post type name is “courses”.

What I need to do is hide any “posts” which have a course_date older than the current date (ie only show courses that are happening today or in the future).

Below is my current WP Query

<?php
$args = array(
	'post_type' 		=> 'courses',
	'meta_key' 			=> 'course_start', 
	'orderby' 			=> 'meta_value_num',
	'order'				=> 'ASC',
	'posts_per_page'	=> '4',
	'paged' 			=> $paged,
	'meta_query'		=> array(
				array(
					'key'		=> 'course_type',
					'value'		=> '2 Day TEFL Fast-Track Course',
					'compare' 	=> '='
				)
		),
);
$temp = $wp_query;
$wp_query = null;
$wp_query = new WP_Query();
$wp_query->query($args);

?>

How would I go about doing this?

Thank you.

• Elliot

• December 3, 2013 at 2:07 pm

Hi @deset

Before I start testing your code, can you please read over these existing similar posts?

http://support.advancedcustomfields.com/forums/topic/how-do-i-filter-and-sort-event-posts-with-start-and-end-date/

http://wordpress.org/support/topic/plugin-advanced-custom-fields-sorting-by-date-picker

http://stackoverflow.com/questions/18576092/wordpress-advanced-custom-fields-order-posts-by-date-picker

Looking at these pages you can see the main issue with your meta query is the compare and value are wrong

Thanks
E

• ericjacksonwood

• March 10, 2015 at 7:31 am

I’ve been having some trouble with this as well. I have a “Upcoming Events” page, and a “Past Events” page. Each event has a custom field called “event_date”.

I want to create a loop that displays all of the events greater than today.

From what I’ve gathered in the three links above, I would put this in my functions.php file:

// CREATE UNIX TIME STAMP FROM DATE PICKER
function custom_unixtimesamp ( $post_id ) {
    if ( get_post_type( $post_id ) == 'event_type' ) {
	$event_date = get_post_meta($post_id, 'event_date', true);

		if($event_date) {
			$dateparts = explode('/', $event_date);
			$newdate1 = strtotime(date('d.m.Y H:i:s', strtotime($dateparts[1].'/'.$dateparts[0].'/'.$dateparts[2])));
			update_post_meta($post_id, 'unixstartdate', $newdate1  );
		}
	}
}
add_action( 'save_post', 'custom_unixtimesamp', 100, 2);

Then I would add something like this to my page template:

<?php 
							$today = time();

							$args = array(
								'post_type' => 'event_type',
								'posts_per_page' => 5,

								'meta_query' => array(
									array(
										'key' => 'unixstartdate',
										'compare' => '>=',
										'value' => $today,
									)
								),

								'meta_key' => 'event_date',
								'orderby' => 'meta_value',
								'order' => 'ASC',
							);

							$query = new WP_Query( $args );
							$event_type = $query->posts;
							?>
							<?php if ( have_posts() ) : while ( have_posts() ) : the_post(); ?>

Right now that’s not turning up any results. My post-type is called “event_type”, and the key is “event_date”.

Any thoughts on where I’m going wrong?

• Anonymous

• March 10, 2015 at 11:45 pm

1. Galaupoker.com Agen Judi Poker dan Domino, Taruhan Poker Dan Domino Uang Asli Terpercaya
2. Cahayapoker.com Agen Judi Poker Dan Domino Uang Asli Online Terpercaya Indonesia