There are similar posts on this site about the same topic, if you look around. But here is your answer: To make this work you need to change your date format.
You can sort alphabetically, or numerically, not calender-merically. The only human date format that orders correctly is YYYY/MM/DD. The separator are optional and shouldn’t matter. Your format is never going to sort the way you want.
Alternately, you could store your dates in Unix time format and convert them to ‘human’ when you display them, which is what I’d do.
You could also write your own function to sort things but you will need to query and then sort, which is extra overhead.
Related Posts:
- Sort custom post type by multiple custom fields
- Where are custom field values stored in the database
- Orderby meta_value only returns posts that have existing meta_key
- ORDER BY custom field value
- How to position a custom field before the editor
- Auto sort the wp-admin post list by a meta key
- Date, Time, and Timezones
- Retrieve custom fields on Categories, using WP-API
- Archive sorting functions by custom fields (front-end)
- How to sort a table of custom posts by column containing custom field
- Order by custom field date with ASC order
- Ordering posts by anniversary using only day and month
- Using Custom Function With Advanced Custom Fields
- automatically set “Featured Image” the same as the og:i that is set in a custom field
- Problem with adding exta field in metabox in custom post type
- How can I sort get_users() by any value (last_name, user defined fields and more)
- Copying Custom Meta Values from existing post to a duplicate post
- How can I query on the year part of a complete date in a custom field?
- Calculate the sum of certain the_sub_fields
- Is it possible to order posts by two meta values?
- Displaying posts with only upcoming dates according their custom field date value
- Displaying Custom Fields on Post with Genesis Child Theme
- ACF won’t load from a custom JSON location
- Custom column sorting in WordPress admin post table
- Show ACF fields only on certain page in the backend
- How can I pass a variable set by ACF to header.php?
- Sorting posts ordered by custom field value
- Dynamically fill a post custom field with post publish date
- How can I store a file in the database in the same way WordPress and ACF do?
- Advanced Custom Fields: Sorting custom columns with custom fields sorts only by date
- WP_User_Query pulling ACF to loop
- How to add Advenced Custom Fields In Single Post
- How to schedule a custom field value update?
- Add new image block, set default class name and update it using Javascript
- Advanced Custom Fields dynamic update_field
- WooCommerce – Adding Custom Fields To Invoice
- Change the sort order for posts to include custom field
- Sort alphabetically by custom field
- WP Group posts by year(desc) > month(desc) > date(asc)
- Vimeo thumbnails
- Walker class for sub-menu with ACF fields
- How to list Category list in ACF Pro’s Select Field to choose from [closed]
- ORDER BY custom field value out of where clause
- Get all the posts where meta field with multiple choice has several values checked
- wordpress custom loop ascending descending posts by custom field
- Querying posts by latitude and longitude to build a Google Maps with several markers
- ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
- Get users based on month ACF datepicker field
- Retrive Image URL of Custom Fields in Theme
- Convert all dates stored in custom field
- Let Users Filter Posts by Custom Fields
- Filter posts by custom field (Advanced Custom Fields)
- How can I output the custom fields wrapping with HTML
- Displaying an ACF list of users
- How To Show Get Adjacent Posts If Posts Are Sorted By Custom Field
- Custom field Search with Relavanssi
- How to get custom image field of specific post id
- Listing the most popular 8 city (custom fields) as used in posts
- Custom Query Fields – Altering Meta Value
- How to order posts by number of Vimeo Likes
- How to query posts by month based on date custom field?
- Order by custom date field
- Group Posts By Custom Meta Value: Date
- Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
- How To Save Data From Remote APIs To ACF?
- comments_where Hook
- ACF field group not showing in page
- get_field values for each post on home page using wp_add_inline_style
- Problem with revisions only returning four results
- Is there any way to make a custom field for a post only if the author is a certain user?
- WordPress Admin – Automatically Sort Custom Posts by Custom Field Date Value in d-m-Y Fomat
- Weird custom fields data lost
- adding autosave feature to custom fields
- ACF – Compare user and post data
- Wrap group of wp query posts to parent div by date/year
- How to add content with a filter when there’s no content in the editor
- Query Posts based on custom field value
- Using ACF Custom Field value in a URL with do_shortcode() [closed]
- Get month and day from a Date Picker custom field
- display Flexible Fields from options
- Sort custom fields in admin by last field added
- Display Child Page with custom fields within Parent Page
- Thirtieth century date for a post
- Display different category template if custom field is checked
- Order a query by meta_value and then by post_date
- How to filter post using custom feild value in shortest and longest duration?
- How to Order Posts by Custom Fields?
- Fetch data from a WP page with same name as current username
- WordPress archives by custom field and date
- Get custom field from other post in carousel
- list pages by custom_field?
- Advenced custom fields auto fill problem
- Adding custom field to an array
- Add image custom attribute [closed]
- Order by a meta field in query loop
- How to get all specific fields from one ACF Group?
- Truncating characters in Advanced Custom Fields works some places but not others?
- Conditional display based on ACF checkbox
- acf field repeater link don’t work
- How to add an ACF only for parent term?