JQL question: How to wirte the query to find issue with StartDate+30days a specific day ?

Question

There doesn't seem to be a way to add days into date field to run a query.  Like finding issues with StartDate+30days > a specific day.

We can only do Start Date > 30d. or Start date > StartofDay(+30) and alike.

For reporting purpose I would like to add extra days into the date field then pull the result.

Please kindly advise if there a way to do this.  Thanks.

Alan Luk · Answer

Thanks Alex.  Looks like the date and time function work based on Now() only.

Gerda Grantiņa _ eazyBI · Answer

Hi @Alan Luk 
As you mentioned that you need this JQL for reporting purposes, then maybe you want to try out the reporting app - eazyBI!
With that, you can create different reports where you can either use the cell formatting option to mark issues with dates that are past some start date.
Or you create a calculated measure to filter out issues with that condition, see available options in the app: DateCompare() and DateAddDays().

See the eazyBI demo account for different use cases: https://eazybi.com/accounts/1000/dashboards/14871-chart-types

best,
Gerda // support@eazyBI.com

Alex_dddmmh · Answer

Hi @Alan Luk

If you are running a JQL from the Issue Navigator, I am afraid you cannot add days to a field in runtime. But if your use permits, you could leverage smart values from Automation for Jira.

Here is a Date and Time functions reference.

I hope it helps,

Cheers,

Alex