Forums

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

Create quick filter for tasks where TODAY is within a date range

Emily Michelle Jones January 31, 2019

How do I create a quick filter to see anything that has a due date of the current day? So far I have this ""Due Date" = endOfDay()" but it's not working. 

 

Would love help on this! 

 

Thanks,

Emily

2 answers

0 votes
Haran Kumar
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.
January 31, 2019

Ask Jack said your title and body doesnt match , so I'm bit puzzled up. Anyways to answer your question considering the title , I think this should work.

project = "Project Name" AND duedate <= endOfDay() AND duedate > -1d. 

Emily Michelle Jones February 1, 2019

I tried using your JQL as well but it is also not working. See attached. Would love your feedback on this! duedate.JPG

Haran Kumar
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.
February 3, 2019

In the place of "project name" you are suppose to give your Jira project name for which you are querying. Do not take the same statement.  Say if your project name is BUG the query goes like this 
project = BUG AND duedate <= endOfDay() AND duedate > '-1d'

Haran Kumar
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.
February 3, 2019

To enable the same query on all projects in your jira, take out the project field.
ie.,
duedate <= endOfDay() AND duedate > '-1d'

0 votes
Jack Brickey
Community Champion
January 31, 2019

Your title and body don’t seem to align. However if you want to show things that are due today then...

duedate = today()

will get you there

Emily Michelle Jones February 1, 2019

I tried using that JQL but it's not working--see screenshot attached. Would love your feedback on this! duetoday_jira.JPG

Jack Brickey
Community Champion
February 1, 2019

you look to be on a Server instance? Can you switch to "Advanced" query?

Jack Brickey
Community Champion
February 1, 2019

your image is presenting something foreign to me. Can you tell me if you are on Cloud or Server? can you provide a full screen shot so I can figure out where you are at?

In cloud you can do the following:

click magnifying glass, click view all issues, delete the text in the search box and paste in what i recommended.

In Server, navigate to the Search Issues view and click Advanced and paste in the JQL

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events