Take a look at meta.php:777:
... CAST($alias.meta_value AS {$meta_type}) {$meta_compare} {$meta_compare_string})...
So if you want to use DATE comparisons, you should use MySQL compatible date formats (YYYY-MM-DD).
Change this part of your code:
array(
'key' => 'date',
'value' => date("Y/m/d"),
'compare' => '>=',
'type' => 'DATE'
),
to:
array(
'key' => 'date',
'value' => date("Y-m-d"), // <- change
'compare' => '>=',
'type' => 'DATE'
),
and it should work just fine.
Related Posts:
- How to filter a dd/mm/yyyy date from a custom field in a query
- WP_Query – Order results by meta value
- Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
- Filter WP_Query for posts having a certain meta-value
- Can I query custom meta data through WP_Query
- Meta Query with AND & OR?
- Sorting a query by custom field date
- Convert jQuery Datepicker Format to SQL Date Format
- How do I search an array stored in a custom-field using WP_Query?
- Date, Time, and Timezones
- How do I order by multiple custom fields using wp_query?
- Trying to perform complex custom field query with order by set to field value
- Query meta field using between
- Order Posts by Closest Numeric Values
- 2 orderby in wp_query with 2 custom fields
- Can serialized arrays in DB be matched against serialized arrays with meta_query?
- How to get a meta value from all post
- Compare meta_query decimals not working right
- WP_Query multiple use of relation and/or
- Query Problem – Show posts within category ‘x’ that have a custom field between ‘y’ and ‘z’
- Using OR in WP_Query negates the “NOT EXISTS” compare
- WP_query : meta_key with custom rule for specific value
- How can I combine meta_query queries?
- custom field value date convert to unix timestamp problems
- Custom Field sort not working (WP 3.8.1)
- Using WP Query to search by multiple meta fields
- Difference between ‘LIKE’ and ‘IN’ in meta queries
- Sort by posts that have a featured image?
- WP_Query display next custom post from today’s date
- Order by value in serialized custom field
- $wp_query meta_key naming issue [closed]
- Author Page Custom Query WHERE author OR [post meta value] OR [post meta value]
- Meta_query and numeric comparison [closed]
- converting custom field date format
- Adding Custom Fields to Search
- Upcoming Event: How do I sort database by custom date field, but ignore past dates?
- Any way to include custom fields in WP_Query results?
- Multiple relationships in a query
- WP Query Returning All Posts
- How do I use wp_query for WordPress search?
- Meta query with timestamp using WP_query
- Conditional custom field query
- Order query by meta_value with multiple custom fields
- Auto Populate Custom Field with Complex Value That Increase by One?
- Show 1 post and after a specific date show the next one
- Custom WP_Query for WordPress Search Results with meta_query
- Meta Query And/Or
- How to combine custom fields to make one order-able value
- Passing meta_box string to post__in?
- Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
- meta_value and meta_key filtering returning no posts [closed]
- Select custom posts by meta_value and sort by a different meta value
- Can’t query by meta_key
- Adding custom field and querying from post table
- wp custom field date format compare
- Query posts using less than
- Meta query relation ‘OR’ not working as expected
- How do I convert all custom_field php timestamps in the database to js timestamps?
- The best way to collision check in WP
- WP_query multiple custom fields not working
- Custom Query Fields – Altering Meta Value
- How to show certain data on certain interval of period
- How to query for posts with either one or another custom field
- Multiple Custom Field Query
- How to update custom field of a posts in a particular category
- How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
- Custom Field Date Problem
- 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?
- Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
- WP Query multiple select form – meta_query help
- How to Order Posts by Custom Fields?
- WP_Query based on multiple metadata comparisons
- Complex WP_Query Using Post Date And Post Meta
- Display posts where date field matches current month?
- Show posts containing or not custom field
- Display agents (custom post type) alphabetically, except one who always shows last
- Query posts by Custom Meta (checkbox) & Genesis Grid Loop
- Search Results Page – Displaying Custom Meta Fields
- Output custom field value
- tax query between operator like
- Display a different image for each page with editor
- Save attachment ID instead of URL in custom field
- Showing Custom Fields on Parent Page
- Changing order in which custom fields appear in dashboard
- Let Users Filter Posts by Custom Fields
- Can wp_insert_post_data filter be used to save custom field data?
- Filter posts by custom field (Advanced Custom Fields)
- How to hide custom fields added by a plugin?
- Comparing Dates from custom field
- How to validation for sanitize_URL?
- Help setting up a sql query
- Advanced Custom fields not available yet during publish_page action
- Meta box values are displayed on Custom Fields list. Is it possible to hide them?
- How can I output the custom fields wrapping with HTML
- Sort posts by custom field value
- Display custom widget value in header.php
- If metabox has content display content
- Gravity Forms Update post meta from template [closed]
- Add custom data (field) to sidebar widgets for later display
- put saved metabox values back into fields and then display on the front end