Forums

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

Show only for Monday of current week

Emma Edey
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!
September 5, 2018

I need to create a filter that will show me only issues where the scheduled date is Monday for the current week.

 

Tried this, but it show nothing:

project = project AND issuetype = Release AND "Scheduled Date/Time" = startOfWeek(1d)

 

Only shows issues if I use Scheduled Date/Time" >= startOfWeek(1d) but that shows all issues from Monday onwards.

1 answer

1 accepted

0 votes
Answer accepted
Alexey Matveev
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.
September 5, 2018

Hello,

The problem is that startOfWeek returns you a date with 00:00 time. And you do not have such issues. The correct way would be:

"Scheduled Date/Time" >= startOfWeek(1d) and "Scheduled Date/Time" < startOfWeek(2d)

Emma Edey
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!
September 5, 2018

Thank you :)

Alexey Matveev
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.
September 5, 2018

You are welcome!

If you feel like I answered your question, kindly mark my answer as accepted.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events