Filter query based on date in custom field

You can use this format of meta_query, although you’d have to change the format of all of your existing expiry-date entries.

'meta_query' => array(
    'key' => 'expiry-date',
    'value' => array($today, $UserInputExpiry),
    'compare' => 'BETWEEN',
    'type' => 'DATE'
)

The second date in the array is the later date and both $today and $UserInputExpiry should be in the format YYYY-MM-DD.

Related Posts:

  1. Using meta query (‘meta_query’) with a search query (‘s’)
  2. ORDER BY custom field value
  3. Can I query custom meta data through WP_Query
  4. Add custom fields to search
  5. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  6. Matching Serialized Arrays with meta_query
  7. Meta Query with AND & OR?
  8. Trying to perform complex custom field query with order by set to field value
  9. Is there a way to do multiple ordering on a multiple meta_query?
  10. WordPress Search Custom Meta Field Only
  11. Compare meta_query decimals not working right
  12. Ordering posts by anniversary using only day and month
  13. Calling Specific Pages with wp query Part II
  14. Loop through two different sets of custom fields
  15. Slow meta query with multi meta keys
  16. Using OR in WP_Query negates the “NOT EXISTS” compare
  17. How can I query on the year part of a complete date in a custom field?
  18. How can I combine meta_query queries?
  19. Displaying posts with only upcoming dates according their custom field date value
  20. Difference between ‘LIKE’ and ‘IN’ in meta queries
  21. Sorting posts by multiple values, combined
  22. meta_value_num sort glitch
  23. WP_Query display next custom post from today’s date
  24. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  25. WP_Meta_Query causing long-running MySQL queries
  26. Sorting posts by custom fields in meta_query
  27. meta_query for a string inside a meta field containing a comma-separated list
  28. Order by custom field value not working for acf date field
  29. Complex WP_User_Query call fails on production server
  30. Meta query with timestamp using WP_query
  31. Orderby custom field meta value ASC and then by date DESC
  32. How make a custom search on backend in WordPress without plugin?
  33. How to add a new meta key and assign timestamp to posts
  34. Get content from pages with same meta_key from Database
  35. WP 3.1 meta_query for multiple custom field values
  36. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  37. Get posts with same meta value as current post
  38. Alter main archive, to show posts with meta as last
  39. Meta Query returns wrong number of posts
  40. Change order of posts
  41. Meta Query And/Or
  42. Use meta_query to get title of associated post
  43. Meta query with multiple custom fields for archives page ordering problem
  44. filter custom field values $min $max
  45. Ordering posts by custom field named “date” in backend
  46. Get Data From wp_sitemeta for Multisite network
  47. Unique meta_key with array value vs repeated meta_key with single values
  48. get posts where a custom field contains a text
  49. WP Query – Is this correct?
  50. How can I do a variable for meta_query?
  51. Avoiding ACF get_field and returning to core WordPress function
  52. ORDER BY custom field value out of where clause
  53. comment meta_query for keys that aren’t yet set
  54. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  55. ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
  56. change order of images attached to post
  57. Meta_query ‘compare’ => ‘LIKE’ not working?
  58. Diamond question mark in text after migrating content
  59. tax query between operator like
  60. Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?
  61. Is it possible to compare the current time with a custom “start” and “end date
  62. How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
  63. Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
  64. Making WP_Query limit results by date before today where date is a meta_query
  65. multiple meta_query and orderby question
  66. get posts based on non-single metadata
  67. Woocommerce products search with custom fields
  68. How to save multiple values with same meta_key, each value linked to another tag id
  69. How to improve my non-unique metadata MySQL entries?
  70. WP meta_query args not working in function
  71. Filtering posts by ACF meta query
  72. Why does my numeric meta query work only on one meta key and not the other?
  73. meta_query to check all custom fields
  74. Query multiple meta values at the same time :
  75. Create Shortcode shows only posts with custom_field meta
  76. meta_query ‘compare’ => ‘!=’ not working
  77. Create custom query for search?
  78. Query Posts Via WordPress URL
  79. Meta_query not filtering posts
  80. Checking if field is set before comparing with meta_query in query_posts?
  81. How do delete a meta key?
  82. Filter Query Post by Custom Fields(by date)
  83. Dynamic background image used in css after selector
  84. WP Query Args – search by meta_key or title
  85. Is there any action filter/hook for validating a custom field before publishing the post?
  86. How to return Meta data from the REST API?
  87. Remove old custom field after import
  88. Arrange custom fields with drag and drop?
  89. custom field with total count of Facebook likes, comments and shares
  90. Allow only one post with specific meta value
  91. Attach images to posts using custom fields (just paths to images already uploaded)
  92. how to display custom fields of post on a web page
  93. How to fill custom fields with brackets in their key with add_post_meta()?
  94. Front-End User Profile
  95. Problem with revisions only returning four results
  96. Permanently show Custom Fields in Editor
  97. Permalink structure depending on custom field
  98. Truncating characters in Advanced Custom Fields works some places but not others?
  99. Conditional display based on ACF checkbox
  100. How to add an ACF only for parent term?