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. WP_Query – Order results by meta value
  13. Using meta query (‘meta_query’) with a search query (‘s’)
  14. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  15. Meta query with string starting like pattern
  16. compare meta_query in get_posts arguments
  17. ORDER BY custom field value
  18. Filter WP_Query for posts having a certain meta-value
  19. Add custom fields to search
  20. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  21. Matching Serialized Arrays with meta_query
  22. WP_Query orderby custom field then post_date in one query
  23. Filtering a WP_Query meta_query by numeric values isn’t working
  24. Getting attachments by meta value
  25. How do I search an array stored in a custom-field using WP_Query?
  26. querying with custom meta field with meta_query
  27. How do I order by multiple custom fields using wp_query?
  28. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  29. Query meta field using between
  30. Order Posts by Closest Numeric Values
  31. Is there a way to do multiple ordering on a multiple meta_query?
  32. 2 orderby in wp_query with 2 custom fields
  33. Can serialized arrays in DB be matched against serialized arrays with meta_query?
  34. How to get a meta value from all post
  35. WordPress Search Custom Meta Field Only
  36. WordPress altering my custom query, How to fix it?
  37. Ordering posts by anniversary using only day and month
  38. Calling Specific Pages with wp query Part II
  39. WP_Query multiple use of relation and/or
  40. Loop through two different sets of custom fields
  41. Query Problem – Show posts within category ‘x’ that have a custom field between ‘y’ and ‘z’
  42. Comparing timestamps in meta query doesn’t work
  43. Display two post types ordered by two custom fields
  44. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  45. Slow meta query with multi meta keys
  46. Order by meta_key in custom post type doesn’t affect the query
  47. How can I query on the year part of a complete date in a custom field?
  48. WP_query : meta_key with custom rule for specific value
  49. Displaying posts with only upcoming dates according their custom field date value
  50. How to filter a dd/mm/yyyy date from a custom field in a query
  51. meta_key and meta_value not working together
  52. Using WP Query to search by multiple meta fields
  53. Sorting posts by multiple values, combined
  54. Compare WP Custom Field date
  55. meta_value_num sort glitch
  56. Sort by posts that have a featured image?
  57. Order by value in serialized custom field
  58. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  59. WP_Meta_Query causing long-running MySQL queries
  60. $wp_query meta_key naming issue [closed]
  61. Author Page Custom Query WHERE author OR [post meta value] OR [post meta value]
  62. Meta_query and numeric comparison [closed]
  63. Order Posts by meta value AND published date
  64. Sorting posts by custom fields in meta_query
  65. Filtering by Post Meta Custom Fields – Performance
  66. meta_query for a string inside a meta field containing a comma-separated list
  67. Order by custom field value not working for acf date field
  68. Adding Custom Fields to Search
  69. Upcoming Event: How do I sort database by custom date field, but ignore past dates?
  70. Any way to include custom fields in WP_Query results?
  71. Complex WP_User_Query call fails on production server
  72. Multiple relationships in a query
  73. WP Query Returning All Posts
  74. How do I use wp_query for WordPress search?
  75. Orderby custom field meta value ASC and then by date DESC
  76. Conditional custom field query
  77. Order query by meta_value with multiple custom fields
  78. WP_Query: include custom post type only with specific meta value
  79. Returning a list of custom post types excluding those without a specific meta_value
  80. How to make Meta Query case sensitive?
  81. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  82. wp_query check if integer exists in custom field’s array
  83. How make a custom search on backend in WordPress without plugin?
  84. Auto Populate Custom Field with Complex Value That Increase by One?
  85. How to add a new meta key and assign timestamp to posts
  86. Get content from pages with same meta_key from Database
  87. WP 3.1 meta_query for multiple custom field values
  88. Fetch Record based on meta key dates
  89. Meta_query with multiple keys and multiple values
  90. meta_query BETWEEN, but the range is stored in the custom field
  91. Extend product search with meta in WooCommerce
  92. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  93. how to make members list directory through wordpress post custom meta key.
  94. Large AND OR query timing out
  95. Get posts with same meta value as current post
  96. Alter main archive, to show posts with meta as last
  97. Meta Query returns wrong number of posts
  98. meta_value_num not ordering all items
  99. Possible to filter custom post type with multiple meta data?
  100. Custom WP_Query for WordPress Search Results with meta_query
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)