Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL - Set Integer Value as a date variable

I have a date field (eg. 12/06/19), End date, and a integer field, Days in Advance.


I would like to set an JQL where the "days in advance" will count backwards from the end date.


When I try, 

"End Date" <= "Days in Advance"d


The query will not work.

1 answer

1 accepted

1 vote
Answer accepted
Ignacio Pulgar Community Leader Dec 10, 2019

Hi Nelson,

There are no native ways of getting the result you seek by native means.

Some third party apps from the Atlassian Marketplace might help, depending on the purpose of the query.

If the number of Days in Advance could be calculated solely based on the current information of other field values form the very same issue, then some potential purposes could be covered natively.

In example, if issues of type Bug and with a High priority have always 7 days in advance, and the purpose of getting the query were acknowledging developers of that, then you could build a filter and subscribe them on a daily basis so that they were notified one day before:

type = Bug AND priority = High AND "End Date" >= -8d AND "End Date" < -7d AND resolution is EMPTY

Other filters would be required for tracking different numbers of days in advance.

We might provide some more help if we counted with more information about your objective.


Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you