How do I compare Target Date to the current date while querying?

[Sofie Palacios]

For example, I'm trying to find all issues with a Target End date within the next 7 days.  

Any help would be so appreciated!!

[Trudy Claspill · Accepted solution]

Hello @Sofie Palacios 

Welcome to the Atlassian community.

date field > startOfDay() and date field <= startOfDay(7d)

You didn't say if you are using Jira Data Center or Jira Cloud, but both have extensive documentation on how to create filters, include details about functions for comparing date fields to relative date values.

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/

[Sofie Palacios]

You're such a lifesaver!! 

Also thank you for the additional links, I'll look through these!! 

[Trudy Claspill]

Glad I could help!

Make sure you look at the documentation that matches your hosting type.

If your Jira URL is https://something.atlassian.net then you are using Jira Cloud. Otherwise you are using Jira Server or Data Center.