- Strapi Version: 3.6.2
- Operating System: macOS
- Database: Postgres
- Node Version: 14.16.0
- NPM Version: 6.14.11
- Yarn Version: 1.22.10
Filtering entries by created_at date gives different results when using corresponding ‘is greater than or equal to’ and ‘is greater than’ filters in admin panel or in the db. For example, *Created_at *
is greater than or equal to Thursday, April 1st 2021 gives 382 entries and *Created_at *
is greater than Wednesday, March 31st 2021 gives 389 entries. It seems that the greater than or equal to filter is missing some of the entries from April 1st, and the greater than includes some (but not all) entries from March 31st. See the attached screenshots.
Why does this happen? Is there a way to actually get the correct numbers with these filters?