Need a query for pulling up the data for 30 days prior and 30 days ahead of a certain date?

Question

Hi,

I am trying to pull up data for a report with below requirement:

30 days prior and 30 days ahead of a certain date.

Tried different queries nothing worked to meet my objective.

I would greatly appreciate if someone could provide suggestions for the JQL to be used.

Thanks,

Kamal

Craig Nodwell_7eve9b · Accepted Answer

Hi @Kamaldeep welcome to the community.  Jira has great date query functions you can find this information here.

Trudy P Claspill · Accepted Answer

Hello @Kamaldeep Welcome to the community. Jira does not have a native method for creating a query where you could plug in a variable that you define elsewhere, like created >= ((-30d)) and created <= ((30d)) If you know the date you want to specify the range around then simply work out the dates that are 30 days before and 30 days after that date, and plug those dates into the JQL. There might be third party apps in the Atlassian Marketplace that could help. Can you tell us more about the problem your are trying to solve, or your use case for this?