WP_Query display next custom post from today’s date

To sort based on a date field, you need to convert the date to a UNIX datetime format. It’s probably best to store the date in a separate custom field. I’ve never had to set this up, but you’d

  1. hook into save_post
  2. look for a custom field with the date in it
  3. convert that to a datetime in a different custom field (probably started with an underscore to hide it from the custom fields interface).
  4. Query for the hidden custom field and use it to sort.

There are also some custom meta box plugins that come with a date picker and the ability to store UNIX format dates.

To do the human-readable date to UNIX conversion, you’ll want to learn about PHP’s strtotime() function. To convert back (if you’re storing the UNIX date and want to print it in a human-readable format), you’ll use the date() function.

Related Posts:

  1. Can I query custom meta data through WP_Query
  2. Meta Query with AND & OR?
  3. Trying to perform complex custom field query with order by set to field value
  4. Compare meta_query decimals not working right
  5. Using OR in WP_Query negates the “NOT EXISTS” compare
  6. How can I combine meta_query queries?
  7. Difference between ‘LIKE’ and ‘IN’ in meta queries
  8. Meta query with timestamp using WP_query
  9. Meta Query And/Or
  10. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  11. How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
  12. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  13. compare meta_query in get_posts arguments
  14. Filter WP_Query for posts having a certain meta-value
  15. Add custom fields to search
  16. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  17. Matching Serialized Arrays with meta_query
  18. WP_Query orderby custom field then post_date in one query
  19. Getting attachments by meta value
  20. How do I search an array stored in a custom-field using WP_Query?
  21. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  22. 2 orderby in wp_query with 2 custom fields
  23. How to get a meta value from all post
  24. WordPress Search Custom Meta Field Only
  25. WordPress altering my custom query, How to fix it?
  26. WP_Query multiple use of relation and/or
  27. Loop through two different sets of custom fields
  28. Query Problem – Show posts within category ‘x’ that have a custom field between ‘y’ and ‘z’
  29. Comparing timestamps in meta query doesn’t work
  30. Display two post types ordered by two custom fields
  31. Order by meta_key in custom post type doesn’t affect the query
  32. How can I query on the year part of a complete date in a custom field?
  33. meta_key and meta_value not working together
  34. meta_value_num sort glitch
  35. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  36. Sorting posts by custom fields in meta_query
  37. Filtering by Post Meta Custom Fields – Performance
  38. meta_query for a string inside a meta field containing a comma-separated list
  39. Any way to include custom fields in WP_Query results?
  40. Complex WP_User_Query call fails on production server
  41. Orderby custom field meta value ASC and then by date DESC
  42. Returning a list of custom post types excluding those without a specific meta_value
  43. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  44. wp_query check if integer exists in custom field’s array
  45. Auto Populate Custom Field with Complex Value That Increase by One?
  46. WP 3.1 meta_query for multiple custom field values
  47. Fetch Record based on meta key dates
  48. meta_query BETWEEN, but the range is stored in the custom field
  49. Large AND OR query timing out
  50. How to combine custom fields to make one order-able value
  51. Use meta_query to get title of associated post
  52. Meta query with multiple custom fields for archives page ordering problem
  53. filter custom field values $min $max
  54. Query based on custom fields start and end date
  55. Ordering posts by custom field named “date” in backend
  56. Unique meta_key with array value vs repeated meta_key with single values
  57. Is it possible to retrieve all posts with a certain value for metadata?
  58. WP Query – Is this correct?
  59. comment meta_query for keys that aren’t yet set
  60. Select custom posts by meta_value and sort by a different meta value
  61. Adding custom field and querying from post table
  62. Getting a custom post’s custom field based on another custom post’s custom field select
  63. Display posts with specific value first in query
  64. change order of images attached to post
  65. tax query between operator like
  66. How to query for posts with either one or another custom field
  67. Is it possible to compare the current time with a custom “start” and “end date
  68. How to update custom field of a posts in a particular category
  69. Query multiple post types, but different order for each
  70. Order by the first array within a meta_query
  71. Query ACF relationship field – Comparator IN – Value array
  72. multiple meta_query and orderby question
  73. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  74. get posts based on non-single metadata
  75. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  76. Woocommerce products search with custom fields
  77. How to save multiple values with same meta_key, each value linked to another tag id
  78. How to improve my non-unique metadata MySQL entries?
  79. Trouble with serialized metadata
  80. Comparing Meta Field date in WPQuery using Meta_Query?
  81. Query against multiple locations within single custom post type post
  82. WP_Query, ACF field and array
  83. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  84. Order by Date Custom Field
  85. Query multiple meta values at the same time :
  86. Create Shortcode shows only posts with custom_field meta
  87. meta_query ‘compare’ => ‘!=’ not working
  88. Using custom field as ‘orderby’ value causing post grouping by publish date
  89. Filter query based on date in custom field
  90. WP Query multiple select form – meta_query help
  91. WP_Query based on multiple metadata comparisons
  92. Checking if field is set before comparing with meta_query in query_posts?
  93. Display posts where date field matches current month?
  94. Querying meta values within an array
  95. How do delete a meta key?
  96. Filter Query Post by Custom Fields(by date)
  97. Query posts by Custom Meta (checkbox) & Genesis Grid Loop
  98. Get posts by meta value except one post [closed]
  99. Dynamic background image used in css after selector
  100. WP Query Args – search by meta_key or title