How to use WP_Query to filter posts modified after a specific date

It is possible, using the date_query argument. By default this uses the publication date, but you can tell it to use the modified date by using the column argument. So if you wanted to query all posts modified after June 30th 2019, you’d use:

'date_query' => [
    'column' => 'post_modified',
    'after'  => [
        'year'  => 2019,
        'month' => 6,
        'day'   => 30,
    ],
],

The column parameter of WP_Date_Query supports:

  • post_date (default)
  • post_date_gmt
  • post_modified
  • post_modified_gmt
  • comment_date
  • comment_date_gmt

A WP shell example for the date query in WP_Query with post_modified_gmt and the after parameter:

wp> echo ( new WP_Query( [ 'date_query' => [ [ 'column' => 'post_modified_gmt', 
  'after' => '2 days ago' ] ] ] ) )->request;

will output:

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM tfl_posts  WHERE 1=1  AND (
  wp_posts.post_modified_gmt > '2019-11-16 10:00:27'

For further information look e.g. into the dev documents here:

https://developer.wordpress.org/reference/classes/wp_date_query/
https://developer.wordpress.org/reference/classes/wp_query/#date-parameters

Related Posts:

  1. How to query posts based on lat-lng coordinate as post meta?
  2. Way to include posts both with & without certain meta_key in args for wp_query?
  3. WP_Query displaying ALL posts
  4. How to trigger 404 for custom query var?
  5. How can I use WP-CLI commands without –allow-root
  6. Calling a wp_query $posts causes a 500 error
  7. WP_query taxonomy + get all posts with two terms from same taxonomy
  8. How do I create my own nested meta_query using posts_where / posts_join?
  9. meta_query not working properly
  10. Best Practice For Querying Grandchildren?
  11. How to combine tax_query and date_query in WordPress
  12. Using tax_query reverses my post_type argument in a custom WP_Query
  13. Custom query, works, but I get a “Notice: Undefined offset: 0…”
  14. How to display 3 different loops in 3 columns on homepage
  15. Get the post thumbnail with wp_query
  16. Where to use $post global variable?
  17. How to display future posts – modified query still yields 404
  18. Multiple instances of Featured Image Query
  19. What’s faster? One big query, or several smaller ones?
  20. Meta Query for specific months
  21. How to apply filter inside a single wp_query?
  22. Overwriting posts_per_page in new WP_Query
  23. Sticky posts are not showing at the top of category posts
  24. WPDB query – decrypting DB data
  25. Storing query variable and then using wp_reset_query
  26. How to use WP_Query without breaking the main Query
  27. Trouble with wp_reset_postdata() in Admin Panel
  28. ACF Date Based wp_query
  29. Database Queries Optimization with new WP_Query
  30. query_vars filter not working even though query string parameter is present
  31. Mysql query and order meta value
  32. Group and list posts by custom taxonomy
  33. Show scheduled posts in main loop but not in WP_Query?
  34. WordPress Pagination changes my template
  35. wp_query ignoring custom post_status
  36. Query posts(CPT, pages , hierarchical) by Ancestor ID
  37. Bypass “supress_filters” in WP Query
  38. meta_query BETWEEN, but the range is stored in the custom field
  39. Input check to custom post type query
  40. Having trouble with WooCommerce Storefront child theme single.php “related posts” modification [closed]
  41. WordPress pagination not working on template search.php
  42. Order ascending is ignored in meta query?
  43. Custom Pagination in Shortcode with WP_Query
  44. Show all data in database table and make it into an interactive table
  45. WP Query – Post Thumbnail
  46. How to filter a query by date in a shortcode?
  47. Search posts missing a particular custom field
  48. Query post with meta value in set of values
  49. Sort by presence of thumbnail
  50. Link Author URL’s based on a custom field
  51. embedding shortcodes in php template
  52. wp-query, pull children of parent page
  53. Max Posts and Memory Limit
  54. How to change tag based on metabox value within $wp_query
  55. What’s missing in this wp_query and meta_query
  56. Tax Query on product_cat using NOT IN as operator does not exclude that category
  57. WP_Query orderby
  58. How to use the Term Object from a custom select field in a query
  59. Random users always showing same 8 users
  60. I have problems with the search query using multiple post types
  61. How to check if logged in user have pending custom post?
  62. whether a nonce is required for get type and get_query_var?
  63. How can I re-query post_type and rewrite the url?
  64. Wp-query and column blocks
  65. Get last child of given page by ID
  66. How to query users by post count no less than 10
  67. Different query result on local and server
  68. Display 3 levels of categories on page
  69. How can I show only last year posts in wordpress archive?
  70. Showing most popular post of week
  71. Related Post by Tags Code
  72. I can’t get post based on its postmeta value and key
  73. Change database image location for transportability
  74. Combine Tax Archive and Meta_Query in WP_Query
  75. Get posts by birthday
  76. Display three sequential posts on each page load, without repeating previous
  77. how to avoid reloading/refresh the page when displaying the post of wp_list_categories
  78. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  79. Optimising amount of calls to custom fields
  80. Issue in If else condition [closed]
  81. Pagination not working with WP_QUERY
  82. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  83. Custom Content Slider stop duplicate
  84. Extract video content from post to display on front page
  85. Hierarchical List Pages as a table
  86. WP_Query with several meta_query-statements and order by meta_value
  87. query_posts, oderby meta_value & print “future” posts
  88. Second wp_query doesn’t appear to be working
  89. difference between methods of query
  90. post__in not recognizing multiple IDs
  91. Related posts with WP_Query
  92. Carousel slider with WP_Query to show 3 posts on each slide
  93. how to use transient method?
  94. wp_query loop with compare operator simply not working, why?
  95. How to replecate the _fields parameter in custom REST api endpoint
  96. I want to place a post before all others from an ACF boleen field
  97. How to put posts with some taxonomy on top of others in `pre_get_posts`
  98. wp_query, calculate with two dates when ‘key’ is text format
  99. Use value from meta key array for use in WP_Query
  100. WP_Query sort by ACF date field (newest first) with blank dates first
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)