Forums

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

Create a filter to show files for the week

Joao Borges
Contributor
April 13, 2020

Hi there,

Trying to create a filter to show all files that were created during  a week, but our  SPRINT week starts on  Thursday and close on the following Thursday.

 

I tried the following

project = DEV AND created > startOfDay(-8d) AND createdDate < startOfDay(1d)

and also 

created > startOfWeek(-4d) AND created < endOfWeek(4)

 

But I was wondering if theres a way to check new tickets created > startofDay( "LAST THURSDAY" ) and createDate < ( "THIS THURSDAY") -

 

Thank you 

 

1 answer

1 accepted

1 vote
Answer accepted
John Funk
Community Champion
April 13, 2020

Hey Joao - What about trying this?

project = Dev and created >= endOfWeek(-10d) AND created <= endOfWeek(-1d) 

Joao Borges
Contributor
April 13, 2020

Hey John I do have something similar to it right now                                                            project = DEV AND created > startOfDay(-8d) AND createdDate < startOfDay(1d)

John Funk
Community Champion
April 13, 2020

That should show you issues created between Last Thursday and this Thursday.  :-)

Joao Borges
Contributor
April 13, 2020

Thanks,  Ill update my filter list 

Suggest an answer

Log in or Sign up to answer