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

[Kamaldeep]

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

[Trudy Claspill · Accepted solution]

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 >= (<date>(-30d)) and created <= (<date>(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?

[Kamaldeep]

Hi @Trudy Claspill 

Thanks a lot!

Yes, I tried that and it worked. Really appreciate for the help.

[Craig Nodwell · Accepted solution]

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

[Kamaldeep]

Hi @Craig Nodwell 

I looked at the resource shared. And that is a great piece of information and quite useful. I was able to build some other filters as well. 

Really appreciate for the help.

Thanks!