order post my meta value m/d/y format with year as included value

The only date format that sorts into human calendar order is “year/month/day”. The separators shouldn’t matter. If you left your dates in UNIX time format, as you get from strtotime, they would sort appropriately as well.

I would recommend re-organizing your code to match one or the other of those formats. I would go further and recommend that you use unix time. If you save those values in UNIX time format, you can easily display them however you want. That is, just use date("m/d/Y", $unixtimeformatedstring) when you display instead of when you save.

I know unixtime is hard to read, but it plus the PHP functions that can manipulate it, is a miracle worker when it comes to dealing with dates (as long as you don’t need dates too far in the past 🙂 )

Related Posts:

  1. How to Get All Posts with any post status?
  2. query_post by title?
  3. Order by meta value or date?
  4. Display posts of the last 7 days
  5. Filtering posts by post meta data
  6. How to query_posts using meta_query to orderby meta_key AND have a secondary sort by date?
  7. Display/query post formats
  8. Help to condense/optimize some working code
  9. query_posts exclude a meta key
  10. Modify main WordPress loop with a parse_query filter
  11. How to make “sticky” pages (and query by them)
  12. Problem with ‘post__not_in’
  13. Sort posts alphabetically by custom field value, insert divider between different letters
  14. using post__in allow duplicate post id
  15. WordPress Custom Query
  16. Help altering a query to exclude all but standard post format
  17. Use union/intersection query_posts variables in uri request parameter form?
  18. query_posts doesn’t order by title
  19. How to limit search to first letter of title?
  20. Custom query with query_posts doesn’t show post without certain meta_key
  21. Post Title displaying but not in the wrapped HTML I need
  22. How to ensure that is_search() return false after query_posts
  23. Inserting Post Using wp_insert_post. How to Fill Yoast Plugin SEO Fields
  24. Post count per (day/month/year) since blog began
  25. Dynamically excluding current page id
  26. How do i paginate query_posts with numeric pagination?
  27. Query_posts $query_string
  28. How to order posts by slug using query_posts/ Wp_query
  29. Query 1 taxonomy term, exclude another
  30. Pagination on custom query
  31. Ordering terms before displaying posts
  32. Sort Posts by Multiple Meta Values [duplicate]
  33. Querying posts with meta value that begins with a certain pattern
  34. Adding Variables to post query
  35. Unable To Get Published posts using query_posts
  36. Read More is not working in query posts
  37. Static Front-Page Excerpts
  38. How to reverse the order of WordPress blog posts?
  39. Tricky WP Query
  40. tax_query operator woes
  41. query_posts() ALWAYS displays something?
  42. Trouble with get_next_post() get_previous_post() returning null
  43. How can i display the posts per week in a particular month?
  44. Possible to display posts containing a short code ?
  45. How to run a SQL Query for character in Post Titles
  46. Authors List page : how to exclude posts from certain category
  47. Using ajax with paging and a custom sub-query
  48. ACF Query meta_values don’t work with ‘offset’
  49. How to retrieve an array of post IDs by a particular value stored in a custom meta’s array
  50. Query a WordPress page by its title (which has a parent page)
  51. define orderby URL with meta_key=post_views_count
  52. Query_posts and attachments
  53. Custom loops, sticky posts, and pagination nightmare
  54. Querying posts only if the current page is not paged?
  55. post_parent array doesn’t work
  56. how to store wordpress loop in array?
  57. meta_query check for meta value in key which holds an array of values
  58. Exclude posts by post meta value
  59. How to place an image after Nth number of posts in query_posts
  60. Related Posts: Notice: Undefined offset: 0
  61. Single-page wordpress theme navigation
  62. meta tag placement for google verification
  63. When to use WordPress loop or Foreach loop?
  64. Can’t get pagination to work for sticky posts only
  65. show x number of posts from y category on homepage
  66. How to Show Comment Count on Related Posts?
  67. How can I show only 5 posts from the relationship?
  68. Frontend form with multiple posts
  69. Way to cache a query for 24 hrs
  70. Make query_post category name dynamic
  71. How can I list posts with different formats depending on order?
  72. query_posts orderby postmeta [closed]
  73. WordPress Query based on random taxonomy
  74. Displaying and Querying Posts with Featured image
  75. View Achive with Category Filter, but Page per post not working
  76. Meta query stopped working
  77. Sticky posts don’t show up first in custom loop
  78. Want Page Descendants when using query_posts post_parent or child_of
  79. grab neighboring content in a query
  80. Querying a query
  81. How do I query based on the modified date?
  82. Is there any way of only retrieving posts with one or more thumbs up (GD star rating plugin)?
  83. How to put orderby on a custom field in query_posts
  84. wp_remote_post and form post
  85. Filter posts by current date ( WP Post Carousel )
  86. How to display most popular post by views count in WordPress?
  87. Sort Posts By Custom Field Date
  88. Custom query posts error
  89. wp_query by last month + sort posts
  90. query_posts not working after wordpress 3.7 update
  91. Post Filter clearing on pagination $_post
  92. Is that the query_posts() the real criminal here?
  93. Query specific posts from parent by slug rather ID
  94. How to limit the number of posts on the home page?
  95. query_posts and sub pages?
  96. How to refine WP-Query with further criteria
  97. Multiple loops with / without sticky posts and different post limits
  98. prevent display duplicate titles on main page
  99. Lots of SQL queries
  100. Limiting the amount of posts this displays

Leave a Comment