Forums › Forums › Search & Filter Pro › PODS Date field range not working with Search & Filter

Tagged: , , , , , , ,

Viewing 4 posts - 1 through 4 (of 4 total)
  • Trevor
    (Private)  January 21, 2019 at 3:54 pm #199515

    Dates need to be stored in the database in the form YYYYMMDD, regardless of how they are then presented in the front end. This screenshot shows you how to ‘check’ what is stored:

    https://www.screencast.com/t/7LnWl9JYJguo

    You don’t leave the field like that, it is just to find out what is there. In the shown example, the stored format is wrong, and will not work.

    Anonymous
    (Private)  January 21, 2019 at 4:40 pm #199521

    Trevor, thank you for your response. Using your screenshot as a guide, it looks like the dates are stored as YYYY-MM-DD (2017-11-15). I’ll see if I can control how they are stored from the PODS plugin.

    Anonymous
    (Private)  January 21, 2019 at 8:13 pm #199547

    Trevor, I switched to using Advanced Custom Fields for the date field I’m using. I made sure that the “Return Format” is using Ymd. And after viewing the field in the database (using the method in your screenshot), it shows the value as 20171115. However, this still doesn’t seem to work when I try and filter the results. Is there anything else I may need to consider?

    Anonymous
    (Private)  January 21, 2019 at 8:24 pm #199555

    Trever, nevermind. I found the issue. I needed to select the “Date Input Format” to use the ACF option. Seems to be working now.

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)