Issue search: compare date with now?
In the regular issue search field (Advanced Search, presumably), is there a way to search for issues with a dateTime field value greater than or less than “now”?
For example, I have a project where the issues have a Start dateTime and a Finish dateTime. How do I search for issues in which #Now falls between the two?
I thought maybe something like "#Now: {Start} .. {Finish}" or something involving < or > operators but no.
Please sign in to leave a comment.
Hello G.K.
To achieve this, you need to use the
..range operator and the wildcard operator*. The full query will be:Start: * .. Today Finish: Today .. *Please feel free to check the examples of open and closed range searches in our documentation here.
Don't hesitate to reach out if any questions arise. Have a nice day!
Thanks! I'm not sure how I didn't figure that out myself, but anyway that simplifies my code a great deal.
Since I'm dealing with times as well as dates I just need to use Now rather than Today.