Filter based off cases in next 2 weeks

Jeremy Banks May 16, 2017

I need to create a filter to show cases that have a "committed date" within the next 2 weeks. I know I can use the endOfWeek() option but need to include 2 weeks. Any advice? 

1 answer

0 votes
Alex Christensen
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 16, 2017

You could try something like this in JQL (I'm assuming your date field is called "Committed Date" for this example):

"Committed Date" < 2w

 

Jeremy Banks May 16, 2017

Thanks for the replay, Alex. It won't work by saying less than 2w. It will let me do < endOfWeek() though. 

ehub@ledcor.com July 9, 2019

This worked for me, thank you Alex. Just what I was looking for.

Suggest an answer

Log in or Sign up to answer