Forums

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

Rolling two week Quick Filter syntax

Chelsea
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!
October 15, 2020

I would like to use a Query in quick search to show a rolling two week list of stories. IS this the right syntax - "Stage Date" >= endOfWeek(2) 

1 answer

1 vote
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.
October 15, 2020

It depends on what "stage date" is for, but we do not really need to know that to explain the behaviour of the functions.

I am not sure endOfWeek() is going to do what you want.  endofWeek(2) might be between 8 and 15 days away from now.

Imagine that it is Wednesday of week 12 of the year today.  endofweek(2) here means midnight a week on Saturday, which is 10 days, not a fortnight.

If you want a simple rolling date (two weeks is the Wednesday after next, but when I get up tomorrow on Thursday, it's the thursday after next), use a simple "date >= +14d"

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events