Problem with writting correctly a query posts args in WordPress

ad1. meta_values are strings, so they are ordered like strings, not dates.
In SQL you should use some casting as a DATE before ordering

ad2. better date format would be yyyy-mm-dd, because sorting this meta field like strings gives the same results as date-type column..

compare order of dates in yyyy-mm-dd

2010-03-06
2012-06-05

and the same dates in dd-mm-yyyy

05-06-2012
06-03-2010

both are sorted (ASC), but the first example is in correct order.

Related Posts:

  1. Change order of posts
  2. query posts custom field calculation value
  3. WP Query – Is this correct?
  4. WP_Query – Order results by meta value
  5. Custom query with orderby meta_value of custom field
  6. Query Posts or Get Posts by custom fields, possible?
  7. ORDER BY custom field value
  8. Sort posts by custom field numeric value using dropdown
  9. query_posts and only show results if a custom field is not empty
  10. Filter archive.php by custom meta
  11. Trying to perform complex custom field query with order by set to field value
  12. Order Posts by Closest Numeric Values
  13. Is there a way to do multiple ordering on a multiple meta_query?
  14. Order posts by custom field and if custom field is empty return remaining posts
  15. Order by custom field date with ASC order
  16. Order Custom post type loop by custom field (datepicker)
  17. Sorting within nested queries / multiple meta keys
  18. Ordering posts by anniversary using only day and month
  19. Order by Custom Field date not recognized
  20. Comments form custom fields order
  21. If value present, order posts by two consecutive custom fields
  22. Query on custom field count?
  23. How to use query_posts() with a date filter on a custom field?
  24. Display custom post types with custom date field value (before today) & order by custom date field
  25. Sorting posts by multiple values, combined
  26. meta_value_num sort glitch
  27. Can ordering post list by meta_value cause performance issue?
  28. Order by value in serialized custom field
  29. Author Page Custom Query WHERE author OR [post meta value] OR [post meta value]
  30. How do I query for a post by custom field?
  31. meta query not showing any results?
  32. Sorting posts by custom fields in meta_query
  33. how can i use custom field in query post
  34. using multiple meta_key and meta_value in query_posts
  35. Query post order by post and desc not working
  36. How can I sort homepage by a meta value?
  37. Order query by meta_value with multiple custom fields
  38. Show 1 post and after a specific date show the next one
  39. How to select posts from multiple categories and metavalues?
  40. meta_compare seems to be treating values as strings instead of integers as expected
  41. Order RSS content by an advanced custom field value
  42. Alter main archive, to show posts with meta as last
  43. Trying to sort and display categories(not posts) by custom field: ‘order’
  44. Meta query with multiple custom fields for archives page ordering problem
  45. filter custom field values $min $max
  46. Ordering posts by custom field named “date” in backend
  47. Query_posts with custom field meta value
  48. Using abs() with custom field in orderby statement
  49. Unable to get specific value from post meta
  50. ORDER BY custom field value out of where clause
  51. Sortable Custom Columns not sorting correct
  52. Meta_query ‘compare’ => ‘LIKE’ not working?
  53. query_posts with meta_value
  54. Custom search SQL Query to add custom field in result
  55. How to put forward a blog post
  56. How can I change the publish date based on a custom field?
  57. Order custom fields alphabetically
  58. Ordering by ‘Title’ OR ‘Custom Field’
  59. Get author total post votes from post meta
  60. How to query posts by month based on date custom field?
  61. simple fields plugin custom query
  62. Ordering by ACF custom field vaule
  63. Sort by an ACF field in a tax_query
  64. WordPress Admin – Automatically Sort Custom Posts by Custom Field Date Value in d-m-Y Fomat
  65. (woocommerce) How to get product id form order id & then retrieve custom meta linked to product?
  66. query_posts -> get page_id from custom field
  67. How to properly get popular Posts by multiple Values
  68. query_posts with sorting on a custom datestamp
  69. Order a query by meta_value and then by post_date
  70. Order by custom field in query multiple
  71. Transfer taxonomy to custom field
  72. Checking if field is set before comparing with meta_query in query_posts?
  73. Filtering posts by WORD in custom field
  74. Display agents (custom post type) alphabetically, except one who always shows last
  75. Filter Query Post by Custom Fields(by date)
  76. Can’t sort custom column on user.php by number / meta_value_num?
  77. How can I avoid re-inventing the Custom Fields wheel in my Plugin’s Metabox?
  78. Does wordpress have something like content-type?
  79. How to get and edit custom fields if in Quick Edit
  80. Create custom field on post draft or publish?
  81. WP_Meta_Query causing long-running MySQL queries
  82. How to validate custom field on lost password form before the user id field?
  83. Woocommerce: Custom fields and email shortcodes, ec_custom_field
  84. Tweak Meta for Post to work it for Pages also
  85. Adding an editable field to template?
  86. Transferring author information from a custom field to a proper author
  87. Linking Custom Fields to Database Records
  88. Stop sending email everytime I updates my post
  89. Best way to store everyday post views?
  90. Show custom field on attachment page?
  91. custom comment_form fields not displaying
  92. WP_Query () using taxonomy, custom post types
  93. Order by custom date field
  94. Group Posts By Custom Meta Value: Date
  95. Custom Field: how to save array of multiple key-values in WordPress
  96. Show Custom Taxonomy as Headline for related posts
  97. display Flexible Fields from options
  98. How to filter post using custom feild value in shortest and longest duration?
  99. Advenced custom fields auto fill problem
  100. Dynamically update Custom Fields to display new dates
techhipbettruvabetnorabahisbahis forumutaraftarium24edusedusedusedueduedusedusedusedusedus