The handy thing about how ACF stores dates as YYYYMMDD
is you can treat them like integers and get a similar level of functionality as if you were using “true” dates.
For example, to get all dates after 1st Jan 2011, use > 20110101
. Those before June 1st 2012? < 20120601
. And for your case, all dates within 2004? >= 20040101 && <= 20041231
.
Translated into a meta query:
$year="2004";
$meta_query_args = array(
array(
'key' => 'production_date',
'value' => array( $year . '0101', $year . '1231' ),
'compare' => 'BETWEEN',
'type' => 'NUMERIC',
)
);
Check out the codex for a full explanation of all the arguments.
Related Posts:
- Ordering posts by anniversary using only day and month
- Displaying posts with only upcoming dates according their custom field date value
- Ordering posts by custom field named “date” in backend
- Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
- Checking if field is set before comparing with meta_query in query_posts?
- Using meta query (‘meta_query’) with a search query (‘s’)
- ORDER BY custom field value
- Can I query custom meta data through WP_Query
- Add custom fields to search
- SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
- Matching Serialized Arrays with meta_query
- Meta Query with AND & OR?
- Date, Time, and Timezones
- Trying to perform complex custom field query with order by set to field value
- Is there a way to do multiple ordering on a multiple meta_query?
- Order by custom field date?
- Order by custom field date with ASC order
- WordPress Search Custom Meta Field Only
- Compare meta_query decimals not working right
- Calling Specific Pages with wp query Part II
- Loop through two different sets of custom fields
- Localized Date Format for Custom Field
- Slow meta query with multi meta keys
- Using OR in WP_Query negates the “NOT EXISTS” compare
- How can I combine meta_query queries?
- Difference between ‘LIKE’ and ‘IN’ in meta queries
- Sorting posts by multiple values, combined
- meta_value_num sort glitch
- WP_Query display next custom post from today’s date
- Which is best in the following scenario : post_meta vs custom table vs parent/child posts
- WP_Meta_Query causing long-running MySQL queries
- Sorting posts by custom fields in meta_query
- meta_query for a string inside a meta field containing a comma-separated list
- Order by custom field value not working for acf date field
- Complex WP_User_Query call fails on production server
- Meta query with timestamp using WP_query
- Orderby custom field meta value ASC and then by date DESC
- How make a custom search on backend in WordPress without plugin?
- How to add a new meta key and assign timestamp to posts
- Get content from pages with same meta_key from Database
- WP 3.1 meta_query for multiple custom field values
- How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
- Get posts with same meta value as current post
- Alter main archive, to show posts with meta as last
- Meta Query returns wrong number of posts
- Meta Query posts not showing on ending date of custom field
- Change order of posts
- Meta Query And/Or
- Use meta_query to get title of associated post
- Meta query with multiple custom fields for archives page ordering problem
- filter custom field values $min $max
- Get Data From wp_sitemeta for Multisite network
- Unique meta_key with array value vs repeated meta_key with single values
- get posts where a custom field contains a text
- WP Query – Is this correct?
- How can I do a variable for meta_query?
- Avoiding ACF get_field and returning to core WordPress function
- ORDER BY custom field value out of where clause
- comment meta_query for keys that aren’t yet set
- ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
- change order of images attached to post
- Meta_query ‘compare’ => ‘LIKE’ not working?
- Diamond question mark in text after migrating content
- Convert all dates stored in custom field
- tax query between operator like
- How show post only from after custom date
- Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?
- Is it possible to compare the current time with a custom “start” and “end date
- How to query posts by month based on date custom field?
- How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
- Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
- Making WP_Query limit results by date before today where date is a meta_query
- multiple meta_query and orderby question
- get posts based on non-single metadata
- Woocommerce products search with custom fields
- How to save multiple values with same meta_key, each value linked to another tag id
- How to improve my non-unique metadata MySQL entries?
- Comparing Meta Field date in WPQuery using Meta_Query?
- WP meta_query args not working in function
- Filtering posts by ACF meta query
- WordPress Admin – Automatically Sort Custom Posts by Custom Field Date Value in d-m-Y Fomat
- Why does my numeric meta query work only on one meta key and not the other?
- meta_query to check all custom fields
- Query multiple meta values at the same time :
- Create Shortcode shows only posts with custom_field meta
- meta_query ‘compare’ => ‘!=’ not working
- Create custom query for search?
- Filter query based on date in custom field
- Thirtieth century date for a post
- Order a query by meta_value and then by post_date
- Query Posts Via WordPress URL
- WordPress archives by custom field and date
- Meta_query not filtering posts
- Complex WP_Query Using Post Date And Post Meta
- Display posts where date field matches current month?
- How do delete a meta key?
- Filter Query Post by Custom Fields(by date)
- Dynamic background image used in css after selector
- Dynamically update Custom Fields to display new dates
- WP Query Args – search by meta_key or title