Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,257,446
Community Members
 
Community Events
164
Community Groups

How do I write a rolling date query?

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 Community Leader Feb 18, 2021

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

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.  

Use 60d and 90d in the same way.

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

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you