[wp-hackers] Get posts by time range

[Dino Termini]

Thank you guys. Hopefully the new wp query extension will be added to 3.5 before it ships. In the meanwhile I think the custom field workaround is a reasonable compromise ;)

Cheers
Dino

On Aug 13, 2012, at 3:47 PM, John Blackbourn <johnbillion+wp at gmail.com> wrote:

> On 13 August 2012 20:31, Dino Termini <dino at duechiacchiere.it> wrote:
>> Hi all,
>> 
>> I have a question about query_posts. I need to retrieve all the articles having a given custom field associated to them, but limited to a specific time range. Is there any way of achieving this without adding a filter to posts_where?
> 
> As Bill points out, there's not a way to do this in core yet. I've
> overcome this previously by adding an 'updated' custom field to every
> post with a MySQL-formatted date string whenever the post is updated
> (or created, depending on the use-case). You can then use that in a
> meta_query like this:
> 
> $meta_query = array(
>    array(
>        'key'     => 'my_key',
>        'value'   => 'my_value'
>    ),
>    array(
>        'key'     => 'updated',
>        'value'   => date( 'Y-m-d H:i:s' ),
>        'compare' => '>=',
>        'type'    => 'DATETIME'
>    )
> ) );
> 
> The 'value' argument for the date can of course be something else such
> as date(  'Y-m-d H:i:s', strtotime( '-3 days' ).
> 
> HTH
> John
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers