How do i create a Date Range that is the Current Quarter

[Ahmad Haynes]

Hello All, 

I am trying to create a report that focuses on just the current quarter. Whenever the quarter changes, the report should change automatically 

I am looking for this code 

status = Closed AND created >=

Unless it's a different code

[Jack Brickey]

You would need to create 4 different filters, one for each quarter. E.g.

Q1 - Project = fit and resolutiondate >= startofyear() and resolutiondate < startOfYear(91d)

Q2 - Project = fit and resolutiondate >= startofyear(92d) and resolutiondate < startOfYear(182d)

the above would show all issues resolved in a quarter. Adjust to meet you exact needs of course As well as actual number of days in the quarter and consider leap year.

you might also consider looking ad Dashboard gadgets some of which have monthly and quarterly granularity, e.g. a Created vs. resolved.

finally consider a PowerBI like solution or even excel itself,

[Ahmad Haynes]

So there isn't one code that allows the system itself to change quarters for you automatically? 

[Jack Brickey]

not that I have ever seen.

[Gene Wood]

I had thought startOfYear("91d") returns the start of the year which is 91 days in the future, not the start of the year + 91 days. (e.g. if today is March 1st 2024, then startOfYear("91d") returns January 1st, 2024, not May 31st, 2024)

But I was mistaken.

I got confused as I was trying to represent months with "3m" but "m" is minutes, I should have been using "3M" for 3 months.