How can I check that today's date matches a specific list of dates.

Nadege_l19417

We have an automation that creates a ticket every weekday. I would like to add a condition to the automation that causes it to skip specific days i.e. tickets are not created for holidays such as Christmas (25/12) or New Year's Day (01/01).

Have tried using smart values but did not manage. Is this possible to do and if so, how can we go about doing this?

Thanks in advanced.

Jovin

Hey @Nadege

Dates can be tricky.... here's my recommendations. I'd go with option 2 personally!

Option 1: IF/ELSE in Automation rule with hard-coded dates

try using the condition in your automation of "IF/ELSE" (no need to use the else as you can add all the dates into the conditions of the first IF).

I would configure it like this (for each date):

• {{smart values}} condition
  • First value: {{now.jqlDate}}
  • Condition: does not equal
  • Second value: date in YYYY-mm-dd format (e.g. 2024-12-25)
    • You can make this dynamic for year by setting it like: {{now.year}}-12-25

A screenshot showing this is below:

Option 2: Visual through using multiple projects

Option 2 allows for some good flexibility by using a proxy project to act as a calendar... it's a funky way but hear me out. Benefits of this is you can easily add or remove dates, AND someone else can manage them without touching your automation!

1. Create a project to act as your "Calendar" (for this I'll use the key "CAL" for the project)
2. Create issues where the Due Date is the date you want your automation to skip
   1. You can import these using the Jira CSV Import function
3. Setup your automation to look at both projects (the one you want it to create issues in, and the calendar project).
4. Setup your automation like below:
5. Action: Lookup issues
   1. JQL: project = CAL AND duedate = {{now.jqlDate}}
6. Condition: {{smart values}} condition
   1. First value: {{lookupIssues.size}}
   2. Condition: equals
   3. Second value: 0
7. Action: Create your issues that you want

See screenshot of flow below: