Using WP_Query to re-query and sort results using a date?

thanks for responses,

Allowed me to find correct answer which I’ve posted below –

$tickets_for_user = get_posts(array(
                                        'post_type' => 'ticket',
                                        'orderby' => 'meta_value_num',
                                        'meta_key' => 'event_date',
                                        'order' => 'ASC',
                                        'posts_per_page' => 1,
                                        'meta_query' => array(
                                                              'relation' => 'AND',
                                                              array(
                                                                    'key' => 'event_date',
                                                                    'value' => array($today,'20991231'),
                                                                    'compare' => 'BETWEEN',
                                                                    'type' => 'DATE',
                                                                    ),
                                                              array(
                                                                    'key' => 'member',
                                                                    'value' => $user_id
                                                                    ),
                                                              array(
                                                                    'key' => 'state',
                                                                    'value' => 'complete'
                                                                    ),
                                                              )
                                        ));

    $tickets = array();
    foreach($tickets_for_user as $ticket) {

Important note from the Codex:

The ‘type’ DATE works with the ‘compare’ value BETWEEN only if the date is stored at the format YYYYMMDD and tested with this format.

You will also have to put the dates in order, with the earliest coming first in the array.

Related Posts:

  1. How to get the posts published in last two days using WP_Query?
  2. Display upcoming events in the next 30 days by querying posts with timestamp in custom meta
  3. WP_Query vs get_posts
  4. What is the most efficient way of querying posts based on visits and date for current day?
  5. Query WooCommerce orders where meta data does not exist
  6. When should you use wp_reset_postdata vs wp_reset_query?
  7. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  8. Show only oldest post by author
  9. Order posts by tags count?
  10. Add and in the header while looping over custom query in page template
  11. Which custom query am I in and how can I access its properties & methods?
  12. Dynamically Override Fancy Title – Part II
  13. Transient pagination not working properly
  14. How to speed up wp_query, took more 5s to run against 100k posts
  15. Date query not inclusive despite parameter being true
  16. List the 5 most recent child pages
  17. How do you query wordpress posts using a math formula between multiple meta field values?
  18. Custom Post order for homepage
  19. Query by custom dates in UNIX Time
  20. Get image of latest post from taxonomies/categories
  21. Page navigation doesn’t show when query category
  22. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  23. Undefined WP_Query::has_posts()?
  24. Is it possible to dynamically get queried term AND taxonomy?
  25. Create ONE callback for all page templates, post filter queries + paginated pages, triggering pagination via AJAX
  26. Pull post meta with post_query?
  27. How to access a query twice in different template files?
  28. Creating a custom search for a specific post type
  29. Minimize database queries to user tables?
  30. Custom query for sidebar isn’t returning results
  31. Query all published post AND attachment with specific mime type
  32. Add quicklink to in the Admin posts page where I can query by a meta_key
  33. Get all products which have both product category
  34. unable to retrive parent page information
  35. How can I create ‘future’ and ‘past’ parameter for restAPI by filtering the CPT custom date field by greater than / less than current datetime?
  36. How to display user order by role
  37. How to use the query hook/filter?
  38. WP Query related posts by tags
  39. Order by summing multiple values
  40. Query posts intersecting tags and categories
  41. Order by empty custom field
  42. Check if loop has any categories?
  43. No results found from a $wpdb->get_results() query when trying to join more than one meta key query
  44. Posts published last 10 minutes
  45. Query only the posts with a post format of “audio”
  46. Modify Search Query if original Query gave no results
  47. Include current post into loop
  48. pre_get_posts – Trying to get property of non-object warning
  49. WordPress query posts with multiple post_meta data
  50. Yoast primary category query modification
  51. Update query for wp_posts and wp_postmeta
  52. Query posts using less than
  53. Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]
  54. WP Query and date format
  55. Write WP Query that selects posts that are part of the same two categories
  56. WP_Query custom order and pagination
  57. Include one page/post into query which is already returning posts
  58. Insert images into wordpress post with a query
  59. Why doesn’t my WP Meta Query return any results?
  60. WP_Query meta compare must include ALL array values
  61. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  62. Prioritising and Ordering Posts By Category Name Using A Custom Loop
  63. Filter products on category AND tag
  64. pre_user_query vs pre_get_posts
  65. Exclude post from wp_query based on custom field boolean
  66. Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
  67. Adding nofollow to all the post links in get_posts with pre_get_posts or WP_Query
  68. Meta query orderby meta_value_num sorting by role first
  69. How to get meta key list efficiently?
  70. Why pagination is not working with tax_query param?
  71. I need query_posts() to order results first by a meta value and then by post ID
  72. WP_Query & Duplicate entries
  73. Add to search posts query array with post IDS which will appear first
  74. WP Query – Search in title or author_name
  75. URL to Post Archive of Custom Query
  76. Query by meta value (add a dropdown of all values)
  77. How to show terms from another taxonomy
  78. My entry results are not consistently alphabetized
  79. Ignoring ‘a’ when sorting posts
  80. Random posts in WP_Query when searching by tag
  81. Custom query for tag and custom tag from 2 post type
  82. wpdb get_results() returns only 2 rows
  83. Query posts in current category but not attachment format
  84. WP_Query secondary query failing
  85. Search Functionality broken by the wp 4.2 update
  86. Issue attempting a wp_query_posts with tags
  87. wp_query – Modify $query to include duplicate content
  88. Optimising specific Query with ACF meta objects
  89. How to get several fields from wp_query?
  90. Combine privileged users array with my current query
  91. Horizontally paginate through sets of blog posts?
  92. WP_Query Sorting Posts by month … timeline effect
  93. Pagination not working with WP_Query (creates links but no page)
  94. Query custom post type by date field only working when two posts match the query
  95. meta_query dates from an array
  96. Divide WP_Query posts by date & post type
  97. Query Posts by date range with fixed beginning and end
  98. query by meta value then date and not empty meta value
  99. New WordPress WP Query using posts from certain categories
  100. How to get posts that have certain meta key value and order based on another meta key’s value