- This topic has 4 replies, 2 voices, and was last updated 6 years, 6 months ago by .
These forums are now closed and remain for historical purposes.
None of the content applies to the new version 3. For support, get in touch via our contact form.
Forums › Forums › Search & Filter Pro › PODS Date field range not working with Search & Filter
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.
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?
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
We also use cookies to store items in your cart as well as allowing your to login on the site.
You can adjust all of your cookie settings by navigating the tabs on the left hand side.
By continuing to use this site, you also agree to our Privacy Policy.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
*Other cookies used for logging in and cart functions will only be used when you use those features and cannot be disabled.
If you disable these cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
This website uses Google Analytics to collect anonymous information such as the number of visitors to the site, and the most popular pages.
Keeping this cookie enabled helps us to improve our website.
Please enable Strictly Necessary Cookies first so that we can save your preferences!
More information about our Cookie Policy