Querying custom post type with 2 custom fields (date-range)

Here is the code I ended up with that works. I should have mentioned that the query was inside the loop, because when I showed it to Damian Taggart of Mindshare Studios, he noticed that he said I should be using WP_Query instead of query_posts. Thanks to Milo and others for attempting to help me without having all the necessary info.

<?php
     $paged = ( get_query_var('paged') ) ? get_query_var('paged') : 1;
     $today = date('Y-m-d', strtotime('-6 hours'));
     $myquery = new WP_Query(array(
     'post_type' => 'exhibitions', 
     'posts_per_page' => 6,  
     'paged' => $paged,
     'orderby' => 'title',
     'order' => 'ASC',
     'meta_query'=>array(
            'relation'=>'AND',
            array(
                'key' => 'exstart-date',
                'value' => $today,
                'compare' => '<=',
                'type' => 'CHAR'
            ),
            array(
                'key' => 'exend-date',
                'value' => $today,
                'compare' => '>=',
                'type' => 'CHAR'
            )
        )
    ));
    if ($myquery->have_posts()) :
    while ($myquery->have_posts()) : $myquery->the_post();
?>

Related Posts:

  1. Using meta_query, how can i filter by a custom field and order by another one?
  2. meta_query for keys that aren’t yet set
  3. WP_Query orderby custom field then post_date in one query
  4. Filtering a WP_Query meta_query by numeric values isn’t working
  5. How Can I save multiple records in same meta key?
  6. order by meta_value serialized array
  7. Comparing timestamps in meta query doesn’t work
  8. Display two post types ordered by two custom fields
  9. How loop through posts based on custom fields
  10. Display custom post types with custom date field value (before today) & order by custom date field
  11. Filtering by Post Meta Custom Fields – Performance
  12. meta_query compare >= not working but
  13. WP_Query: include custom post type only with specific meta value
  14. Returning a list of custom post types excluding those without a specific meta_value
  15. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  16. wp_query check if integer exists in custom field’s array
  17. Filtering custom post type on a combination of custom taxonomies and custom fields?
  18. Meta Query Not Returning Output Despite Having Matching Values
  19. Meta Query Filtering not working on Custom Meta Box using Radio Buttons
  20. Meta Query posts not showing on ending date of custom field
  21. Admin Custom Meta Box – Pull Last 5 Posts from Custom Post Type
  22. How to Output which matched meta_keys were found from custom_type_posts?
  23. Possible to filter custom post type with multiple meta data?
  24. filter search custom field query
  25. How to let users choose where to search for posts?
  26. Query based on custom fields start and end date
  27. Getting a custom post’s custom field based on another custom post’s custom field select
  28. Custom Query: If One Post Object Field Value Is The Same As Another
  29. order the meta query results by 2 custom fields
  30. Using OR relation in meta_query to check for a value before sorting by another
  31. Unable to gather Image URL from Custom Post Type’s; Custom Meta Field
  32. Meta query and compare “!=” not working as expected
  33. Orderby if between two meta fields
  34. Show posts from WP Custom Post Type selected from a field in a metabox
  35. meta query multiple values for the same key
  36. Sort custom post archives by a meta value from a different custom post type?
  37. Custom post types – meta_query: search lesson which starts sooner
  38. Meta_Query refuses to return results
  39. Sort loop by custom field from different post type
  40. Meta_query by date for Events archive
  41. Query events post type after current date and timezone
  42. Selecting posts older than the current Unix epoch timestamp
  43. Unable to get the upcoming events for custom post
  44. WP_Query arguments: Loop through custom post type – get all entries except excluded meta_key?
  45. loop through custom post-type with two meta_keys
  46. Querying meta values within an array
  47. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  48. Get Posts ordered by a date custom meta field
  49. Check for custom field value in different post type than current one and do something
  50. Function to Compare CPT Post Custom Value with Default Posts CF Value
  51. How to Add Custom Fields to a Custom Post Type?
  52. Do_Shortcode not working for Embed
  53. Mixing regular and custom post types (with meta_query) on home page
  54. Get posts based on meta key/value
  55. How to create a wp_query that contains both meta_query and tax_query
  56. Display custom post type and custom fields within a Bootstrap Carousel
  57. how to filter by last name for custom post
  58. Search that will look in custom field, post title and post content
  59. clients list using wordpress
  60. Custom Taxonomy Template Post List with Sort Order
  61. How to filter custom post type archive by meta value
  62. Prevent reload confirmation after AJAX save
  63. Passing Variable as URL Parameter — Security concerns?
  64. Is it possible to define the data type of a Custom Field?
  65. Automatically populate a hierarchical taxonomy from a custom field
  66. Meta_query with relation ‘OR’ killing server CPU
  67. How to add a Custom Meta Box for more than one Post Type?
  68. Give a permalink to Custom Post Types without title
  69. Cannot add custom field to “orderby” parameter in Rest API
  70. Tracking changes in admin-page so user gets warning when leaving the page
  71. How to integrate a form (Ninja Form or Contact Form 7) with Custom Post Types?
  72. First custom field value (out of several) displayed twice after query
  73. Multiple Frontend Filters Using Advanced Custom Fields
  74. WP_query – Filter by tax_query and meta_query using multiple select
  75. Get post content from another section in custom single page
  76. Modify Posts from Custom_Post_Type within the plugin
  77. How to convert custom fields to content
  78. Group by custom field value (start and end times)
  79. Variable Products as custom post types
  80. How to call a post’s metadata in shortcode.php?
  81. WP_Meta_Query object with conditionals
  82. updating one custom meta field only
  83. Confusion about how to use Custom Post Types, Custom Taxonomy or Category?
  84. Displaying Posts Using a Custom Query with a Custom Field and a term_id
  85. Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
  86. How to order query results based on if a custom field has been populated, then the order by the date of the post?
  87. Create an user checklist system for a course plateform using ACF Pro and ACF Extended
  88. How to sort WP_Query by a custom text field (written as a date dd/mm/yyyy)
  89. Auto update publish date of CPT Post if default post custom field value match to cpt post CF Value
  90. Post Click Redirect to Custom URL instead of Single Post Page
  91. wp_insert_post deleting previous post custom meta
  92. Importing URLs of Audio Enclosures
  93. Retrieving custom post type fields without a post
  94. pre_get_posts with multiple post types AND a meta_key
  95. Search form to find custom meta box generated data
  96. Show Custom Post Type taxonomy term that matches custom field
  97. Select Menu for Custom post Type does not save
  98. add_filter > posts_where works partially
  99. Send email on creation of custom post type and use get_post_meta()
  100. WordPress does not show the custom fields box

Leave a Comment