WP_Query ordered by custom field that is a date string?

The WP_Query page on the Codex has a section on Order & Orderby Parameters.

If you want to order the query by a custom field you should add 'orderby' => 'meta_value' AND you must also specify the custom field (called your_date_field in the above example) using the meta_key key in the query. 

$timeline_query = new WP_Query(array( 
    'post_type' => 'post', 
    'orderby' => 'meta_value',
    'meta_key' => 'your_date_field' 
    'posts_per_page' => -1 
));

Related Posts:

  1. When should you use WP_Query vs query_posts() vs get_posts()?
  2. Wp get all the sub pages of the parent using wp query
  3. How to query for most viewed posts and show top 5
  4. WP_Query vs get_posts
  5. Query Posts in a Predefined Order
  6. Order posts by ID in the given order
  7. Custom WP_Query order by post_meta and (author) user_meta
  8. Query Custom Meta Value with Increment
  9. Get posts by meta data OR title
  10. Perform query with meta_value date
  11. Order posts by tags count?
  12. Pass the same object to multiple widgets in a template with one query
  13. Retrieve or Query Pages by ID
  14. How do you query wordpress posts using a math formula between multiple meta field values?
  15. Custom Post order for homepage
  16. How to implement time filter to show random post 1 month for one category and 3 months for other categories
  17. Page navigation doesn’t show when query category
  18. How can I pick a single post from the latest 3?
  19. How to query a custom post type with a taxonomy filter but display post type archive page?
  20. Change query_posts to WP_Query in page but does not work
  21. Custom Query num_rows returns wrong amount
  22. How to orderby multiple meta fields if some fields are empty
  23. Weird orderby => post__in issue
  24. Slow page loads due to WordPress Core Query
  25. Order by summing multiple values
  26. Order by empty custom field
  27. Query Page Content From Theme Options?
  28. How can I override one post and make it display content for another post?
  29. Include current post into loop
  30. Filter post query to only show direct children of category
  31. Should I reset $wp_query?
  32. WP_User_Query orderby meta_val_num
  33. WP_Query custom order and pagination
  34. Why doesn’t my WP Meta Query return any results?
  35. Filter products on category AND tag
  36. pre_user_query vs pre_get_posts
  37. Get posts that match defined arrays of tags
  38. Meta query orderby meta_value_num sorting by role first
  39. Order posts by tags count?
  40. Order by meta date with a thousanth of a second defaults to post order
  41. How to get_comments() ordered by date and parent?
  42. I need query_posts() to order results first by a meta value and then by post ID
  43. WP Query. Ordering posts by another post types meta
  44. How to show post title in content editor in backend?
  45. My entry results are not consistently alphabetized
  46. Merge two queries and remove duplicate
  47. How to order posts, that have already been filtered by custom taxonomy, by their category names?
  48. orderby in WP_QUERY – Use the order from the Dashboard
  49. Ordering Posts by parent category, name ascending
  50. Optimising specific Query with ACF meta objects
  51. How to organize a WP_Query’s list of posts by category and display category title?
  52. When should you use WP_Query vs query_posts() vs get_posts()?
  53. query_posts with sorting on a custom datestamp
  54. How to query post ids liked by the Author
  55. WordPress Query showing multiple titles
  56. Query Posts by date range with fixed beginning and end
  57. custom query to get posts
  58. Get posts that were most recently tagged
  59. new WP_Query with order args – no more distinction between categories
  60. WP Query where title begins with a specific letter
  61. WP_Query order by multiple meta keys & fields
  62. WP_Query: query posts by ids from array?
  63. pre_get_posts with get_posts
  64. How to make an activities stream mixing posts and comments?
  65. How to query for a week using key => value WP_Query argument notation?
  66. SQL query equivalent to WP User Query
  67. How to use filter hook posts_join for querying taxonomy terms in posts_where?
  68. Order posts ascending with number in title
  69. List taxonomy terms plus their latest post ordered by post date
  70. WP query exclude post within the last month / only show over 1 month old
  71. WordPress query for most recent posts from multiple categories
  72. Too many posts cause slow load when paginating
  73. Order Posts by meta value AND published date
  74. Pass array of taxonomy terms to wp_query
  75. How to reduce the number of queries?
  76. List of the years with posts presented
  77. Query custom post type by custom taxonomy (category slug)
  78. Editing the default wordpress search
  79. meta_value_num not ordering all items
  80. Is there a better way to pull in custom content without querying posts?
  81. Reset WordPress Post Query to default
  82. Is_single() conditional tag returns null in query
  83. Show a 404 error page if Public query variable’s value doesn’t exist?
  84. How to give classname to post if post has no content?
  85. Creating attachments archive in tags and categories
  86. Posts limit on homepage (genesis framework)
  87. setting offset to category number in archive page
  88. Query for current post
  89. Query Posts | Combining multiple form inputs into query arguments to generate one filter result
  90. Query Order By Number Variable From API
  91. How to query 5 users in random who have published more than 10 posts
  92. What is the best way to reset a search on a meta_key / meta_value?
  93. Pull posts from all categories if quantity is not met?
  94. Query_post 5 post first / last of post_id
  95. Bring a post to the top of the query if it’s in a certain category?
  96. Using URL variables on a custom WP_Query
  97. Using WP_Query to re-query and sort results using a date?
  98. orderby in WP_query doesn’t works
  99. Converting an existing query_posts to WP_Query
  100. WordPress query very slow on +/- 300k DB entries and 7 INNER JOIN

Leave a Comment