This is not possible, you cannot query sub-values of serialised/structured data in post meta values.
To fix this, you need to store the dates you want to query/filter by as separate post meta key/value pairs. Values need to be string/number/boolean whole values to be queried this way. They cannot be complex structures or sub-strings, such as JSON, arrays, objects
Also note that saving an array or object is a security risk. This is because you can’t save an array/object so WordPress uses PHP’s serialize function, turning it into a string. This exposes you to object deserialisation attacks.
Related Posts:
- how to make members list directory through wordpress post custom meta key.
- How do i create a custom post query when the meta value is an array?
- Getting attachments by meta value
- WordPress altering my custom query, How to fix it?
- How to make Meta Query case sensitive?
- Large AND OR query timing out
- Trouble with serialized metadata
- Query against multiple locations within single custom post type post
- Custom WP_query and integrating into theme file
- query post based on comparison
- Nested meta_query with multiple relation keys
- Can wp_query return posts meta in a single request?
- Use REGEXP in WP_Query meta_query key
- Meta query with string starting like pattern
- compare meta_query in get_posts arguments
- Query Multiple Post types each with own meta query
- meta_query where value is equal to given value
- Query Custom Meta Value with Increment
- Perform query with meta_value date
- querying with custom meta field with meta_query
- Meta Query with date and time on the same Day before given time
- Order by meta_value_num DESC and meta_value ASC on WP 4.0
- What is an efficient way to query based on post_meta?
- WP_Query not working as expected for attachments and custom meta_query
- How do I create my own nested meta_query using posts_where / posts_join?
- How can I create a WP_Query that returns posts where one meta_value
- WP Meta Query for some meta (array) values
- Querying by taxonomy vs Querying by Custom fields Speed Comparison
- How to get sum of meta_values of a meta_key in wp_query according to conditions
- How to query ‘posts_per_page’ to display a different blog posts index template?
- Order by meta_key in custom post type doesn’t affect the query
- How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
- meta_key and meta_value not working together
- Order posts by meta value and Date
- How add a custom posttype name using ACF field to a query post array
- Author Page Custom Query WHERE author OR [post meta value] OR [post meta value]
- Order Posts by meta value AND published date
- Query post with meta_query where date is not in future
- Get meta info related to current post
- Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
- Group WP_Query by meta_key date
- WP_Query last five posts, simply ordered by meta_value
- exclude posts with a specific custom field and value
- Performance when getting post meta for post retrieved by meta value
- Get attachment by meta_key value
- Display custom field meta outside loop, site wide
- Order post type by sum of two custom fields
- Conditional operator OR not working with custom fields
- Display posts with specific value first in query
- Get every post with value in meta key
- Posts query according to meta box date
- Order WP_Query results by meta key value in custom query
- Nested array issue in meta_query
- Display post meta conditionally based on it’s value
- add_query_arg to compare and display events from a certain date
- Show single posts date, in a page of posts
- Comparing 2 Decimal Numbers from custom fields and displaying posts
- Why doesn’t my WP Meta Query return any results?
- Query posts by searching for a string in a meta field
- WP_Query meta compare must include ALL array values
- WP_Query Class custom field parameters
- meta_query weird behaviour, static int will work, but not user data
- Query multiple post types, but different order for each
- Order by the first array within a meta_query
- Query ACF relationship field – Comparator IN – Value array
- ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
- How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
- wp query to use both author id and meta_query
- ElasticPress is (aparently) messing with my search filters
- WP Query – grouping posts by same meta key, adding together values from another key
- Meta query ignores multiple values of the key
- meta_query is overriding default search
- show most viewed post
- Query for current post
- Custom query to retrieve oldest post and retrieve others with date interval
- Comparing Meta Field date in WPQuery using Meta_Query?
- Use WP_query to match post types based on custom field values
- Why can my filter query SOME metadata but not other metadata?
- Getting posts by custom field value
- WP_Query, ACF field and array
- Problem with my loops
- How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
- Order by Date Custom Field
- I need query_posts() to order results first by a meta value and then by post ID
- Query by meta value (add a dropdown of all values)
- Order Posts By Custom Field That is an array of objects
- Orderby query does not work for custom fields even with meta query
- Saving custom fields for WP_Query to retrieve
- Meta key in wp_query bug?
- How to show all the associated posts with specific date of data metabox?
- WP Meta Query at depth 2
- Using custom field as ‘orderby’ value causing post grouping by publish date
- WP_Query Posts by Metadata from Option Tree
- Compare meta key separation
- Sorting Posts with meta value not working
- Return a single custom post from multiple meta queries
- Custom Search Query – include only custom fields and title
- query_posts with sorting on a custom datestamp
- How to query post ids liked by the Author
- Querying meta values within an array