Smart filtering dates not working since 6.4
Hi Support,
Since updating to 6.4 (and every update since) smart filtering (or legacy filtering) our dates column doesn’t work as expected.
No matter what Smart filter I create for this column the results are not correct.
For example a simple ‘Date is before 30/03/2024’ brings back over 8000 posts with Date values ranging from 27/03/2024 up to 03/01/2027
Whereas ‘Date is after 30/03/2024’ brings back only 10 posts with Date values ranging from 27/04/2024 to 30/11/2024
For configuration:
The date column is an ACF Pro datepicker field, display format is set to d/m/y, and return format is set to Y-m-d.
The Admin Columns smart filter settings are set to ACF Date Format (d/m/y)
Checking the database I can see the date values are stored in the postmeta table as Y-m-d (2024-03-30)
I’ve tested different configuration of these formats to try and get the filtering to work, but setting the ACF field and Admin column filter to Ymd format doesn’t improve the results.
This issue only existed after the update to 6.4, we have multiple sites using the exact same data set and those that are on 6.3.5 are still working perfectly.
Any response would be greatly appreciated
Thanks!
You must be logged in to reply to this topic.