Find posts were post_modified is less than now

Resolved David
(@loano1)

1 year, 9 months ago

Hi,

I’m looking for a way to get posts with post_modified date in the future.

The other way round I would use

SELECT * from wp_post where post_modified > NOW()

But how to get posts with post_modified date in the future?

And even more advanced, how could I get all posts whose post_modified date is between 5 minutes and 235 minutes in the future?

Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

(@threadi)

Try this one:

$array = [
    'post_type' => 'post',
    'post_status' => 'future',
    'date_query' => array(
	    array(
		    'column' => 'post_modified_gmt',
		    'after'  => '+5 minutes',
	    ),
	    array(
		    'column' => 'post_modified_gmt',
		    'before'  => '+235 minutes',
	    ),
    ),
];
$result = new WP_Query($array);

Take a look at: https://developer.wordpress.org/reference/classes/wp_query/

Thread Starter

David

(@loano1)

1 year, 9 months ago

Hi @threadi

Thank you for your answer, that works great!

Viewing 2 replies - 1 through 2 (of 2 total)