Only show upcoming event or current events

your are comparing time against wrong time string:

change:

'meta-value' => date('Y-m-d', strtotime('-6 hours')), //value of "order-date"

to this

'value' => date('m-d-Y', strtotime('-6 hours')), //value of "order-date"

because your time string is in m-d-Y format and you are check against Y-m-d which is wrong.

NOTE

if above trick doesn’t work then i suggest you to store time in unix time stamp in database. please read these links for more info how to do it and why

  1. https://designhammer.com/blog/sorting-events-date-using-wordpress-custom-post-types
  2. http://www.billerickson.net/code/create-a-unix-timestamp-based-on-two-meta-fields/

Related Posts:

  1. Display posts with a start OR end date later than current date
  2. Include custom table in query
  3. How to Optimize WP site for millions of posts
  4. Differences between wpdb->get_results() and wpdb->query()
  5. Get Terms by IDs with IDs order
  6. Using WordPress public query variables
  7. How many WordPress SQL Queries per page?
  8. Slow wp_enqueue_media()
  9. Advanced Custom Fields – Query Efficiency
  10. How to display lastest post date in the homepage?
  11. $query->query_var[‘post_type’] not set for pages
  12. How to tell if $query_var isset?
  13. Get IDs of posts currently visible on archive
  14. Sorting Grids with Essential Grid and Events Manger
  15. The use of including upgrade.php when building custom queries
  16. Get the timout value of a saved transient?
  17. Does meta_query work within get_posts array?
  18. Slow meta_query with about 4 milion record on wp_postmeta
  19. How to show more than 5 posts?
  20. WordPress Find Duplicate Post By Content
  21. How many queries are normal to execute on a WP site?
  22. WP Query Sort by meta value (date)
  23. How to optimize my query filtering out unwanted data?
  24. mySQL query. ORDER BY meta_key
  25. Remove posts from query for events whose start date has passed
  26. how to query multiple categories in wordpress?
  27. Disable the MySQL query in the main query
  28. Strange string in console from wpdb query
  29. Update slug (URL) of pending posts via phpMyAdmin
  30. How can I get the query that would be run for the archive page?
  31. Query metas (and not : query posts by metas)
  32. Select query for a login
  33. What’s wrong with my $wpdb prepare?
  34. where should I reset query after using get_results?
  35. Getting post data from private page
  36. SQL query to select posts from multiple categories
  37. Why a URL with a query is always slower than that without a query?
  38. Maintaining Queries in URL
  39. Protect sequence of pages with same password for each of two groups of users
  40. How is it possible to get top comment from all children?
  41. Select Query demand excesive resources [closed]
  42. Create Indexes for Slow Queries
  43. Query to get number of posts last week
  44. MySql Query very slow
  45. I want to create a filter for the query string is this possible?
  46. Exclude categories from the_category();
  47. How can i show all categories using wp query?
  48. All in One Calendar Plugin Custom Post Type Query [closed]
  49. Get Posts from Last 24 hours and Sort them via GD Star Rating
  50. Query returning same results even though the ID changes
  51. Why my query ‘REPLACE INTO…’ does not work?
  52. Restrict query to last day with posts
  53. Custom query object with Simple-Fields custom date field
  54. How to read the value of a WordPress $query associative array (hash) key
  55. Random Page Rewrite
  56. Query posts based on previous query
  57. Waypoints + infinite scroll with custom query
  58. Customizing the_tags output?
  59. Querying with WP query using meta key price
  60. Re-sort get_posts query results
  61. How do I get all results from my query
  62. Taxonomy filter under Polylang
  63. WordPress Mysql query and Duplicate
  64. How to create an overview of posts with the same tag?
  65. create a link to a random post within the current category
  66. How to “orderby” the first array in a meta_query that uses multiply keys?
  67. Pagination not working on custom post types with rewrite slug
  68. JetEngine Query Builder – order by value from repeater
  69. Change pure SQL database query to WordPress post query?
  70. Filter orders by modify date
  71. How to add url parameter to every search query in SearchWp?
  72. Order posts ascending from posts in array
  73. Display data from phpMyAdmin with WordPress
  74. Heavy meta query causing SQL crash
  75. SQL query to list all posts of specific post type with a specific set of associated postmeta values as a column
  76. Sort by postmeta on when searching
  77. Pulling an ACF into a query
  78. Speed up search query that searches in post meta?
  79. Category_in return empty
  80. modifying main query to query for ranges e.g. from 1999 to 2016
  81. Querying users by meta value and getting a strange answer
  82. Using cron for multiple queries
  83. very slow wordpress query with default query
  84. Multilingual WordPress page – using URL to determine language?
  85. Custom Query problem access the values
  86. Set posts per page for parent category and it’s all children
  87. Exclude sticky posts from query
  88. If more than 1 image show post link?
  89. Rewrite Query_Var URL Parameter with Slug
  90. How to query different categories on index?
  91. How to specify what kind of is_single post?
  92. Can’t See Media Queries with Inspect Tool [closed]
  93. Print data from wordpress sql query
  94. Can I create my own query in wordpress with traditional methods?
  95. How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
  96. update $wpdb one query
  97. Admin Post List table Query filtering “WHERE” for custom post type
  98. Ascending & descending posts on same page with IF statement
  99. How to use a dynamic term id for the query block
  100. Meta Query compare with LIKE pulls similar post types: 55 and 155, and 1,155