define83

Hi steve, you can try something like

$allDay = date('Y-m-d H:i:s', strtotime('-1 day'));

$numpost = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' AND post_date > '$allDay'"); echo $numpost;