Order by acf date field.

• [email protected]

• March 8, 2019 at 7:56 pm

Hello! I was trying to order my posts based on ACF date field. The field has a “Ymd” date format (YYYYMMDD) and the orderby is set to meta_value_num. The weird thing is that if order it DESC, the order is correct, but if I order it ASC, the order gets wrong. Would someone have an idea why does this happen? Am I doing something wrong?

I am attaching my ACF settings + the correct and the wrong order display.

acf-settings....jpg

acf-correct.....jpg

acf-wrong.jp....jpg

• John Huebner

• March 9, 2019 at 12:23 am

I’d have to see your query. There must be something in it that’s incorrect or overriding the date field.

• [email protected]

• March 11, 2019 at 7:45 pm

This reply has been marked as private.

• John Huebner

• March 11, 2019 at 11:13 pm

I don’t see anything in your query that should be causing the order to be incorrect. Do you have any plugins and/or filters that could be interfering? A pre_get_posts filter maybe?

• [email protected]

• March 12, 2019 at 8:27 pm

Thanks. It was the plugin “Post types order” that was messing with it 🙂