Is it possible to compare the current time with a custom “start” and “end date

Untested solution, just a thought really, but what if 'value' => 'NOW()' so that you avoid having to pass the date, which seems like it’s probably the issue?

EDIT

Alternate solution: Your SQL date format is wrong. It should be $todaysDate = date( 'Y-m-d' ), that should also be the format it is stored in if the row format is DATE or TIME

Related Posts:

  1. Using meta query (‘meta_query’) with a search query (‘s’)
  2. ORDER BY custom field value
  3. Can I query custom meta data through WP_Query
  4. Add custom fields to search
  5. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  6. Matching Serialized Arrays with meta_query
  7. Meta Query with AND & OR?
  8. Trying to perform complex custom field query with order by set to field value
  9. Is there a way to do multiple ordering on a multiple meta_query?
  10. WordPress Search Custom Meta Field Only
  11. Compare meta_query decimals not working right
  12. Ordering posts by anniversary using only day and month
  13. Calling Specific Pages with wp query Part II
  14. Loop through two different sets of custom fields
  15. Slow meta query with multi meta keys
  16. Using OR in WP_Query negates the “NOT EXISTS” compare
  17. How can I query on the year part of a complete date in a custom field?
  18. How can I combine meta_query queries?
  19. Displaying posts with only upcoming dates according their custom field date value
  20. Difference between ‘LIKE’ and ‘IN’ in meta queries
  21. Sorting posts by multiple values, combined
  22. meta_value_num sort glitch
  23. WP_Query display next custom post from today’s date
  24. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  25. WP_Meta_Query causing long-running MySQL queries
  26. Sorting posts by custom fields in meta_query
  27. meta_query for a string inside a meta field containing a comma-separated list
  28. Order by custom field value not working for acf date field
  29. Complex WP_User_Query call fails on production server
  30. Meta query with timestamp using WP_query
  31. Orderby custom field meta value ASC and then by date DESC
  32. How make a custom search on backend in WordPress without plugin?
  33. How to add a new meta key and assign timestamp to posts
  34. Get content from pages with same meta_key from Database
  35. WP 3.1 meta_query for multiple custom field values
  36. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  37. Get posts with same meta value as current post
  38. Alter main archive, to show posts with meta as last
  39. Meta Query returns wrong number of posts
  40. Change order of posts
  41. Meta Query And/Or
  42. Use meta_query to get title of associated post
  43. Meta query with multiple custom fields for archives page ordering problem
  44. filter custom field values $min $max
  45. Ordering posts by custom field named “date” in backend
  46. Get Data From wp_sitemeta for Multisite network
  47. Unique meta_key with array value vs repeated meta_key with single values
  48. get posts where a custom field contains a text
  49. WP Query – Is this correct?
  50. How can I do a variable for meta_query?
  51. Avoiding ACF get_field and returning to core WordPress function
  52. ORDER BY custom field value out of where clause
  53. comment meta_query for keys that aren’t yet set
  54. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  55. ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
  56. change order of images attached to post
  57. Meta_query ‘compare’ => ‘LIKE’ not working?
  58. Diamond question mark in text after migrating content
  59. tax query between operator like
  60. Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?
  61. How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
  62. Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
  63. Making WP_Query limit results by date before today where date is a meta_query
  64. multiple meta_query and orderby question
  65. get posts based on non-single metadata
  66. Woocommerce products search with custom fields
  67. How to save multiple values with same meta_key, each value linked to another tag id
  68. How to improve my non-unique metadata MySQL entries?
  69. WP meta_query args not working in function
  70. Filtering posts by ACF meta query
  71. Why does my numeric meta query work only on one meta key and not the other?
  72. meta_query to check all custom fields
  73. Query multiple meta values at the same time :
  74. Create Shortcode shows only posts with custom_field meta
  75. meta_query ‘compare’ => ‘!=’ not working
  76. Create custom query for search?
  77. Filter query based on date in custom field
  78. Query Posts Via WordPress URL
  79. Meta_query not filtering posts
  80. Checking if field is set before comparing with meta_query in query_posts?
  81. How do delete a meta key?
  82. Filter Query Post by Custom Fields(by date)
  83. Dynamic background image used in css after selector
  84. WP Query Args – search by meta_key or title
  85. WP doesn’t show Array Custom Fields?
  86. Exclude custom post type from search by custom field value?
  87. add meta box using function.php
  88. How do I use wp_query for WordPress search?
  89. Nav Menu – Add class based on meta keys
  90. Accessing loop functions (e.g the_title or the_content) from post ID
  91. Displaying custom filed content instead of post content
  92. Set featured image from custom field URL
  93. Filter posts by custom field (Advanced Custom Fields)
  94. wp_get_attachment_image_src() with advanced custom fields returning empty
  95. Saving Custom Field that includes Quotation marks
  96. how to execute custom field for structured data?
  97. Why WordPress takes time to make request to save post?
  98. Show comon custom field results?
  99. Display Child Page with custom fields within Parent Page
  100. Show/Hide Featured Image or replace it with custom field [closed]
techhipbettruvabetnorabahisbahis forumuedueduseduseduseduseduseduedusedusedus