Searching for issues based on a month whilst excluding year

[Toby Moore]

Hey everyone!

I have an reminder issue type for annual activities that need to be done annually, these have a date field that I want to flag on a dashboard, but ideally I don't want to keep updating queries or dates so I would like to be able to flag things where the month is the next month.

Any thoughts?

thanks,

[Rilwan Ahmed]

Hi @Toby Moore ,

Try using Startofmonth () JQL f, StartOfYear() JQL functions and play around

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

[Tuncay Senturk]

Hi @Toby Moore 

Unfortunately, JQL doesn’t support extracting or comparing just the month from a date field without year. However, you can use Automation to achieve this. This is what I'd do :

• Create a single-select custom field, e.g. Reminder Month
• Define a Jira Automation to update the field whenever your date field changes
  • Trigger: field value changed -> your date field
  • Action: set Reminder Month to the month name
  • smart value: {{issue.customfield_XYZ.format("MMMM")}}
• Then you can use "Reminder Month" = "May" JQL to fetch those issues.