Reply To: Sorting woocommerce products by ACF Date Picker field

• kopri

• March 7, 2022 at 6:15 pm

The date field is not a sub field, its only grouped with some other fields. I have checked into DB and the date_end field is stored like I mentioned in this format: 02/April/2022
I’m sending you an image of the wp_postmeta table to see how it is stored:

That’s why I’ve used this line of code, to remove the backslash and transform the date into Ymd format, but it still isn’t working:

        $args['orderby'] = date('Ymd', strtotime(preg_replace("/\//", " ", 'meta_value')));

To mention that the latest upgrade was from 4.4.2 to 5.11.4.
I really ran out of ideas how to solve this issue.
Thanks for the help.