Order by custom field date?

There are similar posts on this site about the same topic, if you look around. But here is your answer: To make this work you need to change your date format.

You can sort alphabetically, or numerically, not calender-merically. The only human date format that orders correctly is YYYY/MM/DD. The separator are optional and shouldn’t matter. Your format is never going to sort the way you want.

Alternately, you could store your dates in Unix time format and convert them to ‘human’ when you display them, which is what I’d do.

You could also write your own function to sort things but you will need to query and then sort, which is extra overhead.

Related Posts:

  1. Sort custom post type by multiple custom fields
  2. Advanced Custom Fields: how do I check to see if a value is set in an field? [closed]
  3. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  4. Where are custom field values stored in the database
  5. Orderby meta_value only returns posts that have existing meta_key
  6. ORDER BY custom field value
  7. Advanced Custom Fields – Get custom fields from parent page
  8. Add custom field to the archive page?
  9. Matching Serialized Arrays with meta_query
  10. How to position a custom field before the editor
  11. Auto sort the wp-admin post list by a meta key
  12. Display post_object content using Advanced Custom Fields plugin
  13. Remove old custom field after import
  14. Unable to get Preview of Uploaded image within a Custom Meta box
  15. Date, Time, and Timezones
  16. get_pages sort alphabetically by meta value
  17. Retrieve custom fields on Categories, using WP-API
  18. Archive sorting functions by custom fields (front-end)
  19. How to sort a table of custom posts by column containing custom field
  20. Order by custom field date with ASC order
  21. Change content before writing to database
  22. Order Custom post type loop by custom field (datepicker)
  23. Ordering posts by anniversary using only day and month
  24. Using Custom Function With Advanced Custom Fields
  25. Localized Date Format for Custom Field
  26. automatically set “Featured Image” the same as the og:i that is set in a custom field
  27. Problem with adding exta field in metabox in custom post type
  28. How can I sort get_users() by any value (last_name, user defined fields and more)
  29. Copying Custom Meta Values from existing post to a duplicate post
  30. How can I query on the year part of a complete date in a custom field?
  31. Calculate the sum of certain the_sub_fields
  32. Is it possible to order posts by two meta values?
  33. Displaying posts with only upcoming dates according their custom field date value
  34. Displaying Custom Fields on Post with Genesis Child Theme
  35. Unable to show ACF’s Image Custom Field properly in Genesis Framework [closed]
  36. Login & Register & Custom details WITHOUT plugin
  37. Sorting posts by multiple values, combined
  38. Send Multiple Custom Field Values Through the URL
  39. Sort by posts that have a featured image?
  40. ACF won’t load from a custom JSON location
  41. Custom column sorting in WordPress admin post table
  42. Show ACF fields only on certain page in the backend
  43. Update posts after populating ACF field value [closed]
  44. How can I pass a variable set by ACF to header.php?
  45. sort search results by custom fields using dropdown
  46. WP Custom Fields Metabox Disappears – ACF plugin issue [closed]
  47. Transfer self made functions.php custom fields to Advanced Custom Fields [closed]
  48. Sorting posts ordered by custom field value
  49. Sorting WordPress Posts via Custom Field Values?
  50. ACF: How to get the full field name (meta_key) by a field key?
  51. Dynamically fill a post custom field with post publish date
  52. How can I store a file in the database in the same way WordPress and ACF do?
  53. Will loading too many ACF Fields cause slow down?
  54. Advanced Custom Fields: Sorting custom columns with custom fields sorts only by date
  55. WP_User_Query pulling ACF to loop
  56. Calling the “wp-link-wrap” pop-up modal
  57. Print custom field in Query Loop block
  58. How to add Advenced Custom Fields In Single Post
  59. How to schedule a custom field value update?
  60. WP_Query order by custom field, then randomly order some of results
  61. Order RSS content by an advanced custom field value
  62. Add new image block, set default class name and update it using Javascript
  63. Advanced search by two criteria – sort by location and date (ascending or descending)
  64. Get an advanced custom field after post publish
  65. How to create a dropdown select of all items in an ACF field group
  66. Advanced Custom Fields dynamic update_field
  67. WooCommerce – Adding Custom Fields To Invoice
  68. Change the sort order for posts to include custom field
  69. Sort alphabetically by custom field
  70. Trying to sort and display categories(not posts) by custom field: ‘order’
  71. WP Group posts by year(desc) > month(desc) > date(asc)
  72. Ordering posts by custom field named “date” in backend
  73. Sort WP_Query with numeric custom field
  74. Vimeo thumbnails
  75. Advanced Custom Fields WYSIWYG More tag
  76. Walker class for sub-menu with ACF fields
  77. How to list Category list in ACF Pro’s Select Field to choose from [closed]
  78. ORDER BY custom field value out of where clause
  79. Get all the posts where meta field with multiple choice has several values checked
  80. wordpress custom loop ascending descending posts by custom field
  81. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  82. Custom fields issue [closed]
  83. Querying posts by latitude and longitude to build a Google Maps with several markers
  84. Select custom posts by meta_value and sort by a different meta value
  85. ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
  86. Get users based on month ACF datepicker field
  87. Sort custom post type by most current date picker
  88. How to copy data from a custom field to the post_content?
  89. WordPress creates new lines in postmeta table on post update
  90. change order of images attached to post
  91. Sort posts by clicks on download button
  92. ul list with only as many li’s as filled custom fields
  93. Retrive Image URL of Custom Fields in Theme
  94. Display custom field from the front page on another page
  95. Convert all dates stored in custom field
  96. How to Pass values to Custom Field through PHP in WordPress Posts?
  97. Let Users Filter Posts by Custom Fields
  98. Filter posts by custom field (Advanced Custom Fields)
  99. Advanced Custom fields not available yet during publish_page action
  100. How can I output the custom fields wrapping with HTML

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)