JQL - get current month automatically

[Dana.Harel]

Hi, 

I'm building automation that will create each month a new issue. 

I would like for the issue's summary to contain the name of the current month we are in. 

How can I do it using JQL? 

Thanks

[Bill Sheboy · Accepted solution]

Hi @Dana.Harel 

I am guessing your rule uses the scheduled trigger to create the new, monthly issue.

If so, please take a look at the date time functions for smart values, and the documentation on the format() function: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

With that, you may format the value of {{now}} to be the name of the current month.

Kind regards,
Bill

[Dana.Harel]

Hi @Bill Sheboy thanks!

I am using the scheduled trigger to create new monthly issue.

My wish is that for each issue - the summary will contain the current month's name -
For example "Monthly task - December"

I tried using the documentation attached but it seems like all I can get is the full date.

I tried using:

• {{issue.created.format("dd/MM/yyyy")}}
• {{now.startOfMonth}}

Will you be able to advise?

Thanks

[Bill Sheboy]

That link I provided shows the format() function, and a link out to the examples for the format strings.  Here is one to return the full month name for the current date:

{{now.format("MMMM")}}

[Dana.Harel]

Thanks is worked!!

[Avinaba Deb]

{{now.format("MMMM")}} function gives you the month in string e.g. February. Is there any function that gives the month number like 02 instead of February?

[Bill Sheboy]

Hi @Avinaba Deb -- Welcome to the Atlassian Community!

Yes, there is.  Please follow the documentation link above, and you will find information  for the different format expressions (via a link to the Java docs).

Kind regards,
Bill

[Nic Brough -Adaptavist- · Accepted solution]

JQL finds issues, not dates, so, no, you can't do this with JQL.  You'll need to write something that can get the month name as part of your "create" script/program

[Dana.Harel]

Thanks - where should I write something like this?

[Dana.Harel]

Can I use "getMonth()" or one of - endOfWeek, endOfMonth, and endOfYear; and startOfDay, startOfWeek, startOfMonth, and startOfYear?