<= in filters

[Kelli Keith]

In a filter, I'm adding a date range. Anything modified within that date should appear. To test this I modified an issue today, 3/21. In my formula I have 

updated >= 2022-02-01 AND updated <= 2022-03-21

but it doesn't pull the issue I modified. If I change it to:

updated >= 2022-02-01 AND updated <= 2022-03-22

it does pull the issue I modified today. The first formula should work since its less than OR equal but it's not counting things modified today, 3-21. Anyone know why?

[Sreenivasaraju P · Accepted solution]

Hi @Kelli Keith ,

Welcome to the community.

"2022-03-21" will be considered as "2022-03-21 00:00". so it is returning requests updated before this time stamp.

You can use time stamp also, if you want to search the tickets updated before particular on that date or you use next date.

ex:  updated <= "2022/03/22 06:00" 

updated <= "2022/03/23"

[Kelli Keith]

Thank you!