Sortable Custom Columns not sorting correct

By default meta values will be treated as strings, leading to the result that you get. As you can see from the codex on wp_query you can force a comparison with different formats by defining a meta_type. Like this:

    $query->set('meta_type','DATETIME');

Related Posts:

  1. Order by custom field date with ASC order
  2. WP_Query – Order results by meta value
  3. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  4. Max length of meta_value
  5. ORDER BY custom field value
  6. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  7. Sort posts by custom field numeric value using dropdown
  8. How can I display all values of a custom field from posts with a certain value of another custom field or from certain post types?
  9. get_pages sort alphabetically by meta value
  10. Trying to perform complex custom field query with order by set to field value
  11. Order Posts by Closest Numeric Values
  12. Is there a way to do multiple ordering on a multiple meta_query?
  13. Assign/update the custom field value for all posts
  14. Order Custom post type loop by custom field (datepicker)
  15. Sorting within nested queries / multiple meta keys
  16. Ordering posts by anniversary using only day and month
  17. Order by Custom Field date not recognized
  18. Comments form custom fields order
  19. If value present, order posts by two consecutive custom fields
  20. How to break meta values into different items and avoid duplicates?
  21. WP_query : meta_key with custom rule for specific value
  22. Sorting posts by multiple values, combined
  23. Sorting posts by custom fields in meta_query
  24. How to sort category by custom field value
  25. trim custom field text value and show (…)
  26. Query post order by post and desc not working
  27. How to wrap meta values seperated by comma in ? [closed]
  28. How to create a Custom Meta Box with Name/Value Admin User Input Fields?
  29. Run a check for multiple meta key values
  30. Filter by custom field (meta_key) using JSON API
  31. Order RSS content by an advanced custom field value
  32. Removing link ” from ” on meta_value in custom feilds
  33. Alter main archive, to show posts with meta as last
  34. Sort alphabetically by custom field
  35. Trying to sort and display categories(not posts) by custom field: ‘order’
  36. Change order of posts
  37. Meta query with multiple custom fields for archives page ordering problem
  38. Ordering posts by custom field named “date” in backend
  39. query posts custom field calculation value
  40. WP Query – Is this correct?
  41. Using abs() with custom field in orderby statement
  42. pre_get_posts : only get posts by wp_usermeta value
  43. ORDER BY custom field value out of where clause
  44. meta_value and meta_key filtering returning no posts [closed]
  45. IF Custom field value equals ZERO
  46. List custom field values ​​in alphabetical order without repetition
  47. How to update a custom field in all posts with the value of another custom field in the same post?
  48. Update post meta custom field using block editor
  49. How to add custom filed value after in wp post title
  50. query_posts with meta_value
  51. Order custom fields alphabetically
  52. Ordering by ‘Title’ OR ‘Custom Field’
  53. Show array of meta_value in Edit Post Coloum
  54. Problem with writting correctly a query posts args in WordPress
  55. How to query posts by month based on date custom field?
  56. Making WP_Query limit results by date before today where date is a meta_query
  57. User query – getting values for custom meta keys/fields
  58. get posts based on non-single metadata
  59. Set class if a meta value is set within post archive
  60. Ordering by ACF custom field vaule
  61. Sort by an ACF field in a tax_query
  62. WordPress Admin – Automatically Sort Custom Posts by Custom Field Date Value in d-m-Y Fomat
  63. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  64. (woocommerce) How to get product id form order id & then retrieve custom meta linked to product?
  65. Create Shortcode shows only posts with custom_field meta
  66. 4 Unique Random Posts based on Custom Field Values
  67. How to properly get popular Posts by multiple Values
  68. Order a query by meta_value and then by post_date
  69. Custom Field: Display only if a specific key is selected outside the loop
  70. Order by custom field in query multiple
  71. Can’t sort custom column on user.php by number / meta_value_num?
  72. WP Query Args – search by meta_key or title
  73. Saving multiple custom meta box fields
  74. get Custom field label (select/dropdown) on front end
  75. Can I count every article following extracted meta value?
  76. Best Practice for storing aggregate data by date or other criteria?
  77. Block Editor – Meta values not saved, meta changes to empty array on update
  78. Slow meta query with multi meta keys
  79. Custom Field Multiple Clauses
  80. Send Multiple Custom Field Values Through the URL
  81. $wp_query meta_key naming issue [closed]
  82. using multiple meta_key and meta_value in query_posts
  83. global function to apply filter to custom field
  84. WP_Query orderby not working with meta_value_num and menu_order
  85. How to add a new meta key and assign timestamp to posts
  86. Print custom field in Query Loop block
  87. Collect user custom field in product page woocommerce
  88. Custom field query without duplicates results
  89. Add a custom meta box for client to order CPT posts how they want
  90. querying a custom field
  91. Can’t get video meta from wp_read_video_metadata()
  92. How to write specific HTML code with a specific custom field? [closed]
  93. How to style posts selecting a CSS post_class (added through custom_fields?)?
  94. Meta query relation ‘OR’ not working as expected
  95. How to hide custom fields added by a plugin?
  96. Image upload and path to custom field
  97. Listing posts with a value in a custom field
  98. Using Customizer API vs Custom Meta Box for custom content
  99. Custom meta boxes – add php code inside?
  100. Display different category template if custom field is checked