PODS Date field range not working with Search & Filter

Anonymous

#199510

Hello, I recently upgraded to pro and built a form to search through a PODS date field by range. However, I’m getting no results no matter what. Are there specific settings needed for working with PODS fields?

Trevor

#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

#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

#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

#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