Will this code limit the posts displayed to the last 14 days?

No…but the Time parameters example explains one solution.

Yes this is where i read first but i dont understand how to impliment posts only within the last 14 days.

<?php
  function filter_where($where = '') {
    //posts in the last 14 days
    $where .= " AND post_date > '" . date('Y-m-d', strtotime('-14 days')) . "'";
    return $where;
  }
add_filter('posts_where', 'filter_where');
query_posts($query_string);
?>

Ok I re-read the page you linked to and i overlooked what was plain to see. but now i have another problem.

this is the code;

<?php
//based on Austin Matzko's code from wp-hackers email list
  function filter_where($where = '') {
    //posts in the last 30 days
    $where .= " AND post_date > '" . date('Y-m-d', strtotime('-14 days')) . "'";
    //posts  30 to 60 days old
    //$where .= " AND post_date >= '" . date('Y-m-d', strtotime('-60 days')) . "'" . " AND post_date <= '" . date('Y-m-d', strtotime('-30 days')) . "'";
    //posts for March 1 to March 15, 2009
    //$where .= " AND post_date >= '2009-03-01' AND post_date < '2009-03-16'";
    return $where;
  }
add_filter('posts_where', 'filter_where');
query_posts($query_string);
?>

when i limit the posts to display the last 14 days this also effects the “recent posts” widget. I have the widget to display the last 5 posts but the list stops after the 14 day cut off.

How can i have the time limit on the Homepage Main Section Only, not effecting the widgets and other pages.

Thanks
Steven

Try remove_filter('posts_where', 'filter_where'); after the query_posts.

I’m trying to use this function to display a COUNT of all posts published in the last 30 days, but not actually display the posts.

any hints on getting this done?

[moderated–bump removed. Please refrain from bumping as per Forum Rules]

<?php
  function filter_where($where = '') {
    //posts in the last 30 days
    $where .= " AND post_date > '" . date('Y-m-d', strtotime('-30 days')) . "'";
    return $where;
  }
add_filter('posts_where', 'filter_where');
    $args=array(
      'post_type' => 'post',
      'post_status' => 'publish',
      'showposts' => -1,
      'caller_get_posts'=> 1
      );
$myposts=new WP_Query($args);
remove_filter('posts_where', 'filter_where');
echo 'posts in last 30 days '.count($myposts);
wp_reset_query(); //just in case
?>

Thank you!

the function is returning 1 as the count however, even though there are many more. Any idea why?

Ah, need to use count($myposts->posts). Fixed below with a few changes, posts for last 90 days, with a ‘verification’ loop.

<?php
  function filter_where($where = '') {
    //posts in the last 30 days
    $where .= " AND post_date > '" . date('Y-m-d', strtotime('-90 days')) . "'";
    return $where;
  }
add_filter('posts_where', 'filter_where');
    $args=array(
      'post_type' => 'post',
      'post_status' => 'publish',
      'showposts' => -1,
      'caller_get_posts'=> 1
      );
$my_query=new WP_Query($args);
remove_filter('posts_where', 'filter_where');

  if( $my_query->have_posts() ) {
    echo '<h2>Number of posts in last 90 days is '.count($my_query->posts) . '</h2>';
    while ($my_query->have_posts()) : $my_query->the_post(); ?>
      <p><small><?php the_time('m.d.y') ?></small> <a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></p>
     <?php
    endwhile;
  } //if ($my_query)
wp_reset_query(); //just in case
?>

oh my god… you have SOLVED IT!

I owe you big time.

I know I’m just milking it, but I also need to run this function twice on the same page. My ultimate goal is to have 2 separate counts of all new posts from 2 separate categories.

What do I need to change to do that?

bump