How to query posts by month based on date custom field?

It is not clear what you’re using as a comparison, but WP Query supports meta query comparisons and even has a DATE type.

For example:

    $query = new WP_Query( array( 
                       'post_type' => 'attraction',
                       'meta_key' => 'attraction_date', 
                       'meta_value' => '10', 
                       'meta_compare' => 'LIKE', 
                       'type' => 'DATE' ) );

Using 10 is not going to get you very far, you should use a timestamp.

I have not tested the date parameter in WP QUERY, it should be using/converting all dates to a unix timestamp using strtotime, if not I would suggest doing so.

http://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters
http://php.net/manual/en/function.strtotime.php

Related Posts:

  1. Order by custom field date with ASC order
  2. Ordering posts by anniversary using only day and month
  3. Order RSS content by an advanced custom field value
  4. Alter main archive, to show posts with meta as last
  5. Ordering posts by custom field named “date” in backend
  6. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  7. WordPress Admin – Automatically Sort Custom Posts by Custom Field Date Value in d-m-Y Fomat
  8. Order a query by meta_value and then by post_date
  9. Complex WP_Query Using Post Date And Post Meta
  10. Is there any action filter/hook for validating a custom field before publishing the post?
  11. ORDER BY custom field value
  12. Filter WP_Query for posts having a certain meta-value
  13. How to rename a custom field?
  14. Apply the_content filter to a custom field with multiple values
  15. How can I make wp-pagenavi work on a custom query built upon a form submission? [closed]
  16. Meta Query with AND & OR?
  17. Pass all custom fields through the same filter on post load?
  18. Query posts from current year
  19. Trying to perform complex custom field query with order by set to field value
  20. Order Posts by Closest Numeric Values
  21. Change content before writing to database
  22. WordPress Search Custom Meta Field Only
  23. Order Custom post type loop by custom field (datepicker)
  24. Order by Custom Field date not recognized
  25. Using custom fields in a filter hook
  26. Localized Date Format for Custom Field
  27. Add an advert every nth Paragraph
  28. How can I query on the year part of a complete date in a custom field?
  29. Plugin similar to Taxonomy Drill-Down for custom fields?
  30. Saving custom profile fields
  31. Sorting posts by custom fields in meta_query
  32. Count how many posts have a custom field set
  33. Only display posts after current date
  34. Upcoming Event: How do I sort database by custom date field, but ignore past dates?
  35. Update posts after populating ACF field value [closed]
  36. sort search results by custom fields using dropdown
  37. How to validate custom field on lost password form before the user id field?
  38. Conditional custom field query
  39. Display only past events on that page using Visual Composer Grid Bulider
  40. Create Pop-Up Box with Custom Field Content Inside the Loop
  41. global function to apply filter to custom field
  42. query usermeta from custom field
  43. How to order posts by one custom field and filter them by another one?
  44. Is there any way to get all meta and standard columns for any WordPress object after searching based on meta key and value
  45. Trying to sort and display categories(not posts) by custom field: ‘order’
  46. Change order of posts
  47. Trying to reorder posts by custom field
  48. Limits, not all post are showen when querying for posts by view count
  49. Meta query with multiple custom fields for archives page ordering problem
  50. query posts custom field calculation value
  51. WP Query – Is this correct?
  52. How to Wrote Simple Calculations by Using Custom Fields in Loop?
  53. Get post ids sorted by meta_key
  54. Using abs() with custom field in orderby statement
  55. pre_get_posts : only get posts by wp_usermeta value
  56. Best filter to use for modifying custom fields on a post?
  57. How to display childrens custom fields?
  58. List custom queried terms in the edit-tags.php?taxonomy page
  59. Get users based on month ACF datepicker field
  60. Access ACF fields within custom preview function?
  61. Sortable Custom Columns not sorting correct
  62. Sort posts by clicks on download button
  63. Loop through incrementing custom fields
  64. Order custom fields alphabetically
  65. Custom Theme Fields in Settings Menu – apply filters to one of those fields?
  66. How to change order of posts in admin
  67. How to query for posts with either one or another custom field
  68. How show post only from after custom date
  69. Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?
  70. Get array of posts based on custom field values
  71. Searching with Multiple (Parallel) Criteria on Custom Fields?
  72. Problem with writting correctly a query posts args in WordPress
  73. Filter or order based on custom field
  74. Custom Field Date Problem
  75. Compare ACF date field (if exists) and post date and order DESC
  76. How to show ACF fields in Gridbuilder custom block
  77. Problem with revisions only returning four results
  78. Dynamically populate query source in Elementor post widget
  79. Ordering by ACF custom field vaule
  80. User Filter Options on Archive Page
  81. searching by keywords in post’s metas or pagination links problem
  82. select user with all meta field and field value. I am use Below Query for this ,So any of know another way to fast query instead of below query?
  83. How to properly get popular Posts by multiple Values
  84. Thirtieth century date for a post
  85. Filter and display a specific custom field value [closed]
  86. Query Posts Via WordPress URL
  87. query specific posts according their custom fields, using sql SELECT
  88. Meta_query not filtering posts
  89. Get multiple posts with some custom fields efficient
  90. How to add a prefix to existing custom fields over MYSQL query?
  91. Checking if field is set before comparing with meta_query in query_posts?
  92. Display posts where date field matches current month?
  93. How to check if custom field exists in this widget query
  94. Only show content slideshow if “slideshow” custom field exists
  95. Including inline Custom Fields info with add_filter in functions.php
  96. Sort posts after filtering them through multiple taxonomies
  97. Can’t sort custom column on user.php by number / meta_value_num?
  98. Get posts that were most recently tagged
  99. Dynamically update Custom Fields to display new dates
  100. Set new url from custom post field
techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduseduseduedueduseduseduseduedus