Date query not inclusive despite parameter being true

If you only want to work with yyyy-mm-dd strings, for example '2014-10-10', you could do something like:

'before' => '2014-10-10 + 1 day - 1 second',

'before' => '2014-10-10 + 86399 seconds',

'before' => 'tomorrow 2014-10-10 - 1 second',

'before' => '2014-10-10 tomorrow - 1 second',

or

just append '23:59:59' to your yyyy-mm-dd string

to get 

'before' => '2014-10-10 23:59:59'

Related Posts:

  1. WordPress Custom Query to show posts from last x years
  2. Use meta_query to display events by date in custom field
  3. WP_Query orderby date not working
  4. Get Recent Posts by Date in Multisite
  5. Using WP_Query To Get Posts Randomly From today
  6. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  7. datetime picker, timestamps and meta queries
  8. How to get the posts published in last two days using WP_Query?
  9. List taxonomy terms plus their latest post ordered by post date
  10. How can I hide posts that are over 2 years old
  11. Custom Field sort not working (WP 3.8.1)
  12. Ordering by meta_value AND date NOT WORKING with wp_query
  13. Query by custom dates in UNIX Time
  14. How to show recent and upcoming birthdays using meta_query
  15. Meta Query for specific months
  16. WP_Query meta_query >= date
  17. Complex date range with WP_Query and BETWEEN
  18. Comparing dates in custom field
  19. How to display upcoming events by dat with Modern Events Calendar Lite
  20. Orderby ASC changes to DESC in WP_Query
  21. Complex WP_Query order request: DESC by day, but then ASC by time
  22. How can I show many posts an author has per week?
  23. How can I create ‘future’ and ‘past’ parameter for restAPI by filtering the CPT custom date field by greater than / less than current datetime?
  24. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
  25. Taxonomy and Date in same query?
  26. 2 weeks ago from meta query meta value
  27. Shortcode for latest -not expired- posts
  28. date_query seems to be ignored by wp_query
  29. Posts published last 10 minutes
  30. WP Group posts by year(desc) > month(desc) > date(asc)
  31. Display Current Post’s Position in Custom Taxonomy
  32. WordPress Custom Search Form Displaying Unexpected Results
  33. Filtering posts by archive showing all years
  34. Query posts using less than
  35. WP Query and date format
  36. Ordering posts by custom field and grouped by month
  37. Limit loop to future events
  38. How to show list of posts with custom field value (a date) that are coming soon
  39. Show single posts date, in a page of posts
  40. Added Date Filter To Popular Posts Query
  41. Display upcoming events in the next 30 days by querying posts with timestamp in custom meta
  42. query hook parse_tax_query function takes no effect
  43. Comparing Meta Field date in WPQuery using Meta_Query?
  44. How to get only present and past posts with post_date
  45. WP Query for all events prior to current date
  46. Problem with my loops
  47. Sort posts on custom field AND after that sort on date?
  48. datetime picker, timestamps and meta queries
  49. Get posts by birthday
  50. Display Year and Month from custom field + Age Calculator
  51. Using WP_Query to re-query and sort results using a date?
  52. Year based WP Query
  53. WP_Query Sorting Posts by month … timeline effect
  54. Get post closest to today
  55. Query custom post type by date field only working when two posts match the query
  56. Get posts from similar time as current post
  57. Divide WP_Query posts by date & post type
  58. Query Posts by date range with fixed beginning and end
  59. Issue with sorting by post date and custom post type
  60. Get posts that were most recently tagged
  61. WP_Query sort by ACF date field (newest first) with blank dates first
  62. WP_Query filter Posts by timestamp event (range start and end) and by month (next 12 month)
  63. WP_Comment_Query pagination, delving into the unknown
  64. Getting all user metadata from user
  65. Limit WP_Query to only X results (total, not per page)
  66. How to disable main query?
  67. Use post__in and post__not_in together?
  68. Compile two queries to one set of results?
  69. How can I order Wp_Query hierarchically?
  70. WP_Query ajax loader detect end of posts
  71. How to get count of posts assigned to given category?
  72. Wp redirect to url with ampersand string
  73. Change query based on post type while staying in loop
  74. Custom Pagination Layout for Elementor widget
  75. $WP_Query: How to display excerpt on first post only
  76. How to properly reset a nested WP_Query query
  77. How Can I Change The Tax Query For The Main Loop For Taxonomy Archives?
  78. Copyright: Get first and last date of post type
  79. how to write wordpress query for multiple metakeys checking?
  80. How to display a list of posts in same child category as current post
  81. querying posts with a custom status
  82. Display post meta conditionally based on it’s value
  83. How can i show pagenavi in my author.php?
  84. Randomly select one of last 3 posts
  85. Using WP_Query with multiple loops on one page in search.php
  86. Order by post meta not working with pre_get_posts filter
  87. is_user_logged_in not working from WP-API (wp-json)
  88. WordPress private post won’t display to other admins
  89. Only show tag with the same id as the post
  90. Sort by price wpdb
  91. Show a message if there are no active posts in category
  92. next_posts_link not visible on first page
  93. Filter posts/pages by user_role array
  94. WP_Query with meta_value_num and meta_query not paged correctly
  95. I need value of saved meta to display next to the post it is associated with
  96. Post Query not working after updating to 4.1
  97. Search Query that Includes Custom Table
  98. Pagination with WP_Query not working
  99. Can’t seem to get an else statement correct? [closed]
  100. I want to capture the last day’s (today) posts in a category in the numbered order in acf