List custom post type by custom field date

Question

I'm working with Wordpress and WP-Types plugin and need to sort CPT by a custom field date.

This work fine:

$args = array(
    'post_type' => 'parties',
    'paged' => $paged,
    'meta_key' => 'wpcf-parties_date',
    'orderby' => 'meta_value',
    'order' => 'DESC',
);

The orderby works perfect. On the Database the value of the field date 'wpcf-parties_date' is store in this way ex: 1349481600 .

I have two templates where i need to show past and upcoming Posts. My question is how can i display only the future or past posts regarding the current date?

I try this with no luck.

$args = array(
    'post_type' => 'parties',
    'paged' => $paged,
    'meta_key' => 'wpcf-parties_date',
    'meta_value' => date('d.m.Y H:i:s'),
    'meta_compare' => '>',
    'orderby' => 'meta_value',
    'order' => 'ASC'
);

I using WP_Query for the loop.

Thanks in advance!!

The Alpha The Alpha · Accepted Answer · 2012-11-28T17:47:47

You may try meta_query to check both < and > and also use meta_value_num because your custom field value is numeric (1349481600).

$current_date=strtotime(date('d.m.Y H:i:s'));
$args = array(
    'post_type' => 'parties',
    'paged' => $paged,
    'meta_key' => 'wpcf-parties_date',
    'orderby' => 'meta_value_num',
    'order' => 'ASC',
    'meta_query' => array(
        array(
            'key' => 'wpcf-parties_date',
            'value' => $current_date,
            'compare' => '>'
        ),
        array(
            'key' => 'wpcf-parties_date',
            'value' => $current_date,
            'compare' => '<'
        )
    )
);

Read the documentation for more.

List custom post type by custom field date

1 Answers