WP_Query and two custom fields returns no posts

The first query gives the expected results when the date format was corrected.

$query = new WP_Query(array(
'post_type'=>'games',
'orderby'=>'menu_order',
'order'=>'asc',
'posts_per_page' => 1,
'meta_query'=> array(
'relation'=>'AND',
array(
'key'=>'game_date_time',
'value'=>$nowtoday,
'compare' =>'>'
),
array(
'key'=>'home_team',
'value'=>'Allen',
'compare'=>'LIKE'
)
)
));

Related Posts:

  1. Multiple orderby values in WP_Query
  2. Search multiple custom fields by using meta_query
  3. WP_Query orderby custom field then post_date in one query
  4. how to filter by last name for custom post
  5. Filtering a WP_Query meta_query by numeric values isn’t working
  6. Sorting a query by custom field date
  7. How can I generate a RSS feed based on a custom WP_Query?
  8. Filtering a WP Query result
  9. Display Custom Post Type Fields
  10. Search Custom Post Type with all meta attached?
  11. How to sort CPT by custom meta value (date), and return posts month by month
  12. WP_Query on custom post type not displaying, multiple loops & get_template_part
  13. Using new WP_Query in shortcode in a custom field causes the main post content to not display
  14. WordPress query by multiple Custom fields and order by date
  15. Comparing timestamps in meta query doesn’t work
  16. Display two post types ordered by two custom fields
  17. Get post info inside modal window?
  18. WP Query group/order by category name
  19. Having trouble with custom date field for CPT query (WordPress)
  20. Display posts if a custom field value is equal to another custom field value
  21. Sort by two dates. Default entry date and custom field if present
  22. Conditional to modify query results
  23. Filtering by Post Meta Custom Fields – Performance
  24. wp_query to find posts by year and month
  25. WP Query—Relationship between two custom post types and their fields
  26. How to dynamically attach pictures to a carousel
  27. Get all Posts If has same custom field values in Posts
  28. Custom Post type and Custom Field WP_Query
  29. Including Custom Meta with posts_where query
  30. WP_Query: include custom post type only with specific meta value
  31. WP_Query orderby modified to include custom meta changes
  32. WordPress custom loop filter by meta_key and value with serialize data
  33. Returning a list of custom post types excluding those without a specific meta_value
  34. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  35. wp_query check if integer exists in custom field’s array
  36. How can I get the number of custom post type posts that have a specific attachment image set?
  37. Problem querying Custom post type by custom fields
  38. Orderby CPT custom fields not working
  39. WP_Query order by custom field, then randomly order some of results
  40. Query custom post type with ACF Date
  41. Including metaboxes from custom post types in global search — continued
  42. Query Multiple Custom Posts by Custom Fields
  43. Get Posts by multiple custom fields is not working
  44. Order Custom Post Type by Custom Field Value
  45. First custom field value (out of several) displayed twice after query
  46. Possible to filter custom post type with multiple meta data?
  47. Query based on custom fields start and end date
  48. DIsplaying URL of custom field in last post of certain taxonomy && post type
  49. WP Query ‘posts_per_page’
  50. Display post from a date range from custom field
  51. post_per_page ignored in WP_Query
  52. How to get specific post meta by title or id
  53. Getting a custom post’s custom field based on another custom post’s custom field select
  54. WP_Query orderby not work with meta_key
  55. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  56. Display custom post type for specific user
  57. Custom Post type loop with ACF not displaying properly
  58. Group by custom field value (start and end times)
  59. Cache issue with WP_Query and custom field filtering
  60. How do I list a custom field and custom taxonomies for each result in a loop?
  61. WP query_posts group by meta field related
  62. Custom Form / Search with Custom Post Type Data
  63. Create if else for post types in WP_Query ‘post__in’ values
  64. WP Query from two Custom Post type fields as statement
  65. Alike Shortcode using in Custom Shortcode
  66. Query custom post type that has a serialized relational advanced custom field value
  67. WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
  68. WP_Query get always custom post_type for first
  69. Sort custom post column by generated value?
  70. How can I query and sort custom-post type using WP_Query
  71. How can I fetch all the dates from custom fields from various different custom post types and show / list them at one place in ascending order?
  72. Query custom post type and custom field by URL parameters
  73. Custom meta fields not showing up in WP_Response Object via custom endpoint
  74. meta query multiple values for the same key
  75. Sort custom post archives by a meta value from a different custom post type?
  76. Custom post types – meta_query: search lesson which starts sooner
  77. Post Filtered by Custom Field Value
  78. Filter custom WP_Query by first letter of a custom field – hopefully using Search and Filter Pro?
  79. Meta_Query refuses to return results
  80. WordPress query in which condition uses custom field
  81. How to make a shortcode for my WP_Query Loop? [duplicate]
  82. Error in WP Query. If variable is empty it is displaying previous post value
  83. Query events post type after current date and timezone
  84. Calling specific page with wp query
  85. How to stop wp_query searching pages as well as the specified CPT
  86. Selecting posts older than the current Unix epoch timestamp
  87. WP_Query get posts where post_name is empty
  88. Storing/querying custom date data
  89. Query recent posts by author
  90. 404 on Pages for Custom Post Type & Query_Posts
  91. Querying meta values within an array
  92. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  93. Filter Custom post type by another Custom post type
  94. Show Posts in Vertical Tabs with Scrollbar
  95. querying to custom field over ACF REST API
  96. Display ACF object field data using Elementor Custom Query
  97. WordPress custom field sorting, weird behavior: the latest post is at the end
  98. Sort CPT by taxonomy AND THEN by custom field
  99. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?
  100. Query order by a numeric ACF field