WP_Query search custom posts meta date fields

See the codex re Meta Query.
For example, this would get all posts at least a day old:

$date = date('Y-m-d H:i:s',strtotime("-1 days"));  // 1 day ago

meta_query' => array(
        array(
            'key'       => 'name of your key',
            'value'     => $date,
            'compare'   => '<=',
            'type'      => 'DATETIME',
        ),
    )

Related Posts:

  1. Query all posts where a meta key does not exist
  2. Exclude a category from WP_Query
  3. Single loop for wp_query and wp_user_query
  4. WP_Query orderby custom field then post_date in one query
  5. query multiple taxonomies
  6. Custom Post Type, WP_Query and ‘orderby’
  7. Include post id[s] into WP_Query()
  8. Syntax to get the Nth item in a list of custom post types?
  9. Grab 5 latest posts from custom post type ‘announcements’
  10. “pagination” (but not really) and queries using custom posts types
  11. Sorting a list of posts displayed under a list of associated terms (which should be sorted without initial articles)
  12. Query for posts from any post type but only add instock products
  13. Query not returning CPT posts
  14. Unable to display multiple post types in same query (WPML WP_Query)
  15. Pagination not working
  16. How to use custom post type APIs, but use a different db table
  17. Display all Posts and only certain Custom Post Types with meta fields
  18. Select menu should display categories and the item’s depth
  19. Custom Post Order for a Custom Post Type
  20. Why does using WP_Query inside a shortcode in an elementor page cause the arguments for WP_Query to get malformed?
  21. Lists Posts from CPT that match the Title of the Page
  22. Filtering by Post Meta Custom Fields – Performance
  23. Unable to get paginate_links working with a custom query [duplicate]
  24. Returning a list of custom post types excluding those without a specific meta_value
  25. query private custom post type
  26. Randomize Posts. Skip the first post in ascending order
  27. Pagination for Custom Taxonomy Page [duplicate]
  28. Custom loop with multiple taxonomy queries
  29. Isotope Filtering with Bootstrap Tabs – Custom Post Type Query Loop in each Tab (Have to click twice to filter)
  30. Custom taxonomy rewrite give pagination 404
  31. WP_Query order by custom field, then randomly order some of results
  32. creat filter with wp_query
  33. How to do WP_Query with two meta fields with orderby clause
  34. Get Posts by multiple custom fields is not working
  35. Custom query at top of archive search page, arguments are overridden
  36. How to have this permalink structure: post_type/postname/custom_inner_page
  37. Sort entries by date mixing two post types
  38. custom post type search by reference id
  39. Custom Taxonomy Not Showing in Front-End When Outputting a Custom Post Type with WP_Query()
  40. Print current post category during WP_Query
  41. Multiple Custom Post Type queries, how to DRY it up
  42. WPDB for post count on post
  43. post_per_page ignored in WP_Query
  44. WP_Query parameter conflict
  45. Retrieving meta-box from a custom-post-type
  46. Cannot get custom post
  47. Custom post type and standard post not displaying or working
  48. Display custom post type for specific user
  49. Get all post from a post type
  50. Trying to add a class to post links
  51. A faster way to query custom post types with multiple conditions?
  52. Custom Post Type Archive Pagination
  53. List all Custom Post Type posts excluding certain Taxnomy term
  54. WP_Query: Posts within category OR custom post type
  55. Custom post type pagination error
  56. WP query_posts group by meta field related
  57. posts_per_page in custom WP_Query does not override “Reading” settings?
  58. WP Query from two Custom Post type fields as statement
  59. Display Parent-Child Posts in specific order by comparing IDs in array
  60. custom post type and a “sticky” position taxonomy
  61. Display post count for a specific month
  62. Query to Exclude Child Pages from Custom Post Type Archive
  63. WP_query has incorrect wp_posts.post_name = ‘asc’ when I have custom post type called ‘order’
  64. Randomizing WordPress Custom Post Type Sorting Through Them Without Page Refresh
  65. Order posts alphabetically with numbers but some of the posts has numbers in the title
  66. How to output custom post type title on custom page with category next to it?
  67. How to sort by multiple values in a nested WP_Query
  68. SEARCH QUERIES – REVERSE OUTPUT
  69. post_type incorrect for custom post type
  70. Live search by custom tag
  71. Staggering featured post using ‘sticky’
  72. Ajax load more inside custom post type taxonomy
  73. How to get the posts that my following users are liked?
  74. Only show categories that have posts within custom post type
  75. Create a custom wp_query from a specific custom post type with specific taxonomy
  76. SQL LIKE in WP_Query
  77. How can you use a page for a custom post type?
  78. Display all Custom taxonomy terms and their relevant custom posts
  79. Query breaking with ‘posts_per_page’ => -1
  80. WP Query with multiple post types ordered by custom meta date then published date
  81. CPT Efficient way to display posts from different categories with custom query
  82. How To Loop Through list with Custom Post Types
  83. CPT or Custom Table for Repository of Serial Numbers
  84. Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
  85. Custom Post Type + Category archive
  86. Values inside a custom field to determine which category posts to display
  87. WP_Query get posts where post_name is empty
  88. How do I sort post listing by child post count?
  89. Pop up showing same content on all posts display.
  90. Custom post-type’s pagination not working in category.php
  91. Querying meta values within an array
  92. Count of posts with meta_key filled in?
  93. Filter Custom post type by another Custom post type
  94. Archive page – problem with pagination
  95. Are custom posts included when getting a categories’ posts?
  96. Query order by meta value force specific tag first
  97. Quering array of post types & pagination. Articles are repeating sometimes on different pages
  98. How can I show posts with the same tag?
  99. Load posts via AJAX without draft status
  100. WP Query – Can’t get posts with specific taxonomy

Leave a Comment