datetime picker, timestamps and meta queries

WordPress sets the php timezone to UTC for internal calculations. So at 4pm PST, date() will be producing a date that reads 10pm UTC. Hence the event is considered past.

There are two ways to resolve this.

  1. (The preferred method) Store dates in the database in UTC. Handle all date calculations in UTC, and convert to the desired timezone on output (frontend and back).

  2. Use date_i18n()for creating the date to query (as this will set the date according to your blog timezone).

Related Posts:

  1. datetime picker, timestamps and meta queries
  2. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  3. Use meta_query to display events by date in custom field
  4. Query by custom dates in UNIX Time
  5. 2 weeks ago from meta query meta value
  6. Display upcoming events in the next 30 days by querying posts with timestamp in custom meta
  7. WP_Query filter Posts by timestamp event (range start and end) and by month (next 12 month)
  8. WP Query Args – Title or Meta Value
  9. Meta query with string starting like pattern
  10. Does tax_query really beats meta_query in all situations?
  11. Query WooCommerce orders where meta data does not exist
  12. Execute a large WP_Query with many “AND” Meta_Queries?
  13. Using WP_Query To Get Posts Randomly From today
  14. Query all posts where meta value is empty
  15. WP_Query min and max values
  16. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  17. querying with custom meta field with meta_query
  18. Order by two meta keys
  19. multiple meta key but get server load is very high
  20. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  21. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  22. How to get the posts published in last two days using WP_Query?
  23. Meta-value query
  24. Meta query field order together with post_date order causes posts without the meta field to be unordered
  25. How to show recent and upcoming birthdays using meta_query
  26. pre_get_posts filter meta_query without conflicting existing meta_query
  27. Undefined property: WP_Query::$post
  28. Programmatically set ‘meta_query’ for filter
  29. Using WP_Query and WP_Meta_Query Outside of WordPress
  30. WP_Query meta_query >= date
  31. Extending woocommerce admin product search
  32. WP_Query on custom field and order results
  33. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  34. Adding an array from a query string to a WP meta_query
  35. Query multiple meta values
  36. Optional Meta Query
  37. Query by multiple meta elements not seeming to work – wordpress is timing out
  38. How can I create ‘future’ and ‘past’ parameter for restAPI by filtering the CPT custom date field by greater than / less than current datetime?
  39. Extend product search with meta in WooCommerce
  40. How does one perform a sub query with different post types
  41. how to make members list directory through wordpress post custom meta key.
  42. WP_Query with meta_query dosen’t return results
  43. meta_compare not comparing whole integer
  44. How to provide meta_key array to wp_query?
  45. meta queries do ‘either/or’ checks
  46. How to set up hierarchical relationships without using plugins / meta query
  47. WP Query ordering on a meta field for posts with a date in the future not ordering by datetime
  48. Selecting posts with a given meta value for a meta key
  49. Meta query compare for ID’s greater than specific ID
  50. Get every post with value in meta key
  51. get_page meta query not working, maybe a bug?
  52. Is it possible to add relation between meta_query and tax_query?
  53. Query by date from custom field
  54. Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]
  55. WP Query and date format
  56. Show single posts date, in a page of posts
  57. Comparing 2 Decimal Numbers from custom fields and displaying posts
  58. WP_Query Class custom field parameters
  59. Sort posts using multiple custom fields and menu_order in single query?
  60. meta_query where the meta value is not the post title
  61. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  62. Order (by ASC) posts with meta_key so posts without values are last
  63. Search filter between promo and exact price
  64. meta_query with meta values as serialize arrays
  65. meta_query is overriding default search
  66. Multiple WP_Query args combinations according to post type
  67. WordPress Meta Query Null Values Order
  68. WP_Query multiple value not working
  69. show most viewed post
  70. Why can my filter query SOME metadata but not other metadata?
  71. Getting posts by custom field value
  72. Unusual high query of user meta data
  73. wordpress multiple meta value query is not working
  74. Strange results from WP_Query
  75. Pre get posts sort by meta key returns no results if meta key does not exist
  76. meta_query with relation = AND not working as expected when combining EQUALS with NOT EQUALS
  77. WP Query for Multiple Post Types
  78. Order Posts By Custom Field That is an array of objects
  79. WP Query Meta Query
  80. Query custom meta value – post view and date meta
  81. Slow query when selecting with large meta query or post__in
  82. How can I modify standard search query to include also ACF custom fields values?
  83. Custom WP_query and integrating into theme file
  84. WP_Query – show posts where meta value and user_email match
  85. WP Meta Query at depth 2
  86. Best way to Order Post in Home without a plugin
  87. WP_Query using meta_query with LIKE doesn’t return what it should
  88. Return a single custom post from multiple meta queries
  89. Sorting: custom query with orderby meta_value_num THEN by title
  90. query post based on comparison
  91. Including ‘cat’ => $cat breaks meta_query
  92. Query string form $_GET[‘value’] is not working as meta value in wp_query
  93. Can’t figure out query logic
  94. WP_Query orderby not working on custom post_type
  95. 294 Queries on Mainpage of WordPress
  96. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  97. Get posts using multiple values from ACF checkbox as meta query wordpress
  98. get_post_meta bringing back results, but $wpdb->postmeta doesn’t
  99. Custom query with custom filtering returning incorrect results
  100. WP Query returning all posts when Meta_query is null