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. SQL query based on two different custom field values
  86. Sort posts based on an acf field called fecha value return longtext ‘20240517’
  87. Advanced Custom Fields: how do I check to see if a value is set in an field? [closed]
  88. WP_Query – Order results by meta value
  89. Add filter menu to admin list of posts (of custom type) to filter posts by custom field values
  90. getting all values for a custom field key (cross-post)
  91. How to add a custom field in the advanced menu properties?
  92. Custom query with orderby meta_value of custom field
  93. How to filter post listing (in WP dashboard posts listing) using a custom field (search functionality)?
  94. Can I exclude a post by meta key using pre_get_posts function?
  95. Add validation and error handling when saving custom fields?
  96. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  97. Show Custom Fields in Quick Edit
  98. Where are custom field values stored in the database
  99. Validating Custom Meta Box Values & Required Fields
  100. Max length of meta_value
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)