I need data closed between Fridays. How do I use EndOfWeek() and StartOfWeek() functions?

[Darya_Koyfman]

I send reports on Fridays. So, I need to retrieve issues closed after last Friday and the Friday I send the report. I tried to play with EndOfWeek() and StartOfWeek() functions but I'm afraid I am missing something. The output is not correct.

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

What query did you try?

status changed to closed after startOfWeek(-1) before endOfWeek(-1)

will get you issues where status was changed to closed between last Sat morning and this Sat morning. I went for Sat morning because you need to omit last Friday but include this one. Does that wok for you?

You can tweak the duration as you wish.

[Darya_Koyfman]

Hi Jobin,

Thank you for your help!

I used different combinations of these functions and +/- of days and weeks and got completely confused. Your query works if I change second minus to plus: 

project = "TEST PROJECT" AND status changed to closed after startOfWeek(-1) before endOfWeek(1)

This one retrieved the right data. 

Thanks again,

Darya.

[Lorenzo Bueno]

Hello Darya, 

Perhaps this link can help you with what you need:

• Advanced Searching

I Hope this helps!

[Darya_Koyfman]

Thank you Lorenzo!