Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Startofweek and endofweek in a filter don't work on Fridays.

Victoria Harpe May 11, 2018

I have a filter that uses the following:

created >= startOfWeek(-9d) AND created <= endOfWeek(-9d)

This works fine normally, but the last 2 fridays (5/4 and 5/11) the results seem to assume it's the week before!  So for today it shows April 17, 2018 through May 3, 2018.

It goes back to normal on Monday.  

Any suggestions??

 

1 answer

0 votes
Deyves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 17, 2018

Hi Victoria,

Just to make sure that we're on the same page, could you please confirm what's your goal?

Also, I noticed that you're using the startOfWeek(-9d) but this is not valid. What happens if you remove the "-9d" and run the filter again?

Kind Regards,
Deyves Senger

Victoria Harpe May 18, 2018

the -9d works every other day of the week.  And in fact it seems to be working today.  Perhaps it's an anomaly?  

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events