How to filter to show specific tasks that were created or resolved in a certain month?

[Chiho Chan]

hi. i think this is a very basic question and would love some help.

i need to filter by all BIGTASKS that have component CC BUT AND only show those that were either CREATED or RESOLVED in August 2019. how do i do the date part of that in this equation?

project = BIGTASKS AND component = CC 

[Payne · Accepted solution]

If you wish to make it flexible and not tied to a particular month you could do this:

created > startOfMonth() OR resolved > startOfMonth()

Or, if you do wish to target a particular month, you could do this:

(created >= 2019-08-01 and created < 2019-09-01) or (resolved >= 2019-08-01 and resolved < 2019-09-01)

Whichever you use, surround it with () and combine it with your other criteria, e.g.

project = BIGTASKS AND component = CC AND (created > startOfMonth() OR resolved > startOfMonth())

[Chiho Chan]

Thanks mate, it worked!