Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I write a rolling date query?

Christine Williams February 18, 2021

I need to write a query that will provide a rolling 30, 60 and 90 day look from current date.  I've tried using the now(90d) but must not know exactly how to write it because I'm getting an error "Function 'now' expected '0' arguments but received '1'."

1 answer

0 votes
Derek Fields _RightStar_
Community Champion
February 18, 2021

don't use now(). just write "dueDate > 30d" 

Christine Williams February 18, 2021

thanks! That is helpful for items that are 90 days out.  I want to see items that are due in 30 days, 60 days then 90 days.  

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 18, 2021

Use 60d and 90d in the same way.

lenajeannette_smith
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 8, 2022

Is there a way to do a rolling 90 day query; for example, JAN FEB MAR, FEB MAR APR, MAR APR MAY; realizing that some months will have >90 days?  Or will the > 30, >60 >90 work?  If so, can you provide an example of the query using year, 2021 ?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events