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 🙂