[Bug] Searching by "last modified" returns unexpected results

[johnclary]

When using the advanced search filter on the "Last modified" field, the "greater than" operator returns records which are one day earlier than the search value.

[johnclary]

we should double check if this is still an issue. it might be a timezone problem?

[chiaberry]

I couldnt get it to return records a day before the I requested, but I did notice that if I searched for projects greater than 8/11/2022, I was getting projects that were modified on 8/11, when I expected to only get that if i chose greater than or equal to

what I think is happening is its searching for projects greater than 8-11-2022 midnight , and our projects timestamps look like "2022-08-11T14:45:01.064085+00:00", which is greater than midnight 8-11

[mddilley]

Just found another example of this using Construction Start. Also worth noting that the before operator that uses _lt works as expected with no results returned that fall on the input date. But, using before or on that uses _lte does not return projects with construction start dates that are on the input date - just those before it.

Adv search:

Query:

Results: