nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to check holidays fall in between two dates

Omprakash Thamsetty

Hi,

I have start Date and End date so how I can check holidays fall in between these two dates?

How many holidays fall ?

I have script runner plugin. How can I write script to find this?

Any help much appreciated.

Accepted answers

Kawan Diogo_ykfovu

Hi @Omprakash Thamsetty

You can use scriptrunner to generate a script field to hold the value or use as a script check in

Script Console, however you gonna need mantain an array with the holidays of the year, i know it's possible connect with some services to get the holidays of the year, but some of them are paid service, so you can also explore the connection with public API's to get the information and keep them in the array.

Here is the manual version of the script i mencioned:

import java.time.LocalDate
import java.time.format.DateTimeFormatter

// Input dates (you can replace these with your issue's field values or parameters)
def startDate = LocalDate.parse("2025-01-01", DateTimeFormatter.ISO_DATE)
def endDate = LocalDate.parse("2025-01-10", DateTimeFormatter.ISO_DATE)

// Define the list of holidays (in YYYY-MM-DD format)
def holidays = [
LocalDate.parse("2025-01-06"),
LocalDate.parse("2025-01-09")
]

// Filter holidays that fall within the range
def holidaysInRange = holidays.findAll { it.isAfter(startDate.minusDays(1)) && it.isBefore(endDate.plusDays(1)) }

// Output the result
def holidayCount = holidaysInRange.size()
log.info("Number of holidays between ${startDate} and ${endDate}: ${holidayCount}")

// Return the final value
return holidayCount

Let me know it this helps you.

Best Regards

All comments

Kawan Diogo_ykfovu

Hi @Omprakash Thamsetty

You can use scriptrunner to generate a script field to hold the value or use as a script check in

Here is the manual version of the script i mencioned:

import java.time.LocalDate
import java.time.format.DateTimeFormatter

// Input dates (you can replace these with your issue's field values or parameters)
def startDate = LocalDate.parse("2025-01-01", DateTimeFormatter.ISO_DATE)
def endDate = LocalDate.parse("2025-01-10", DateTimeFormatter.ISO_DATE)

// Define the list of holidays (in YYYY-MM-DD format)
def holidays = [
LocalDate.parse("2025-01-06"),
LocalDate.parse("2025-01-09")
]

// Filter holidays that fall within the range
def holidaysInRange = holidays.findAll { it.isAfter(startDate.minusDays(1)) && it.isBefore(endDate.plusDays(1)) }

// Output the result
def holidayCount = holidaysInRange.size()
log.info("Number of holidays between ${startDate} and ${endDate}: ${holidayCount}")

// Return the final value
return holidayCount

Let me know it this helps you.

Best Regards

Ram Kumar Aravindakshan _Adaptavist_

Hi @Omprakash Thamsetty

I've given a similar script using ScriptRunner's Behaviour in this Community Question.

Thank you and Kind regards,
Ram

Omprakash Thamsetty

Hi @Kawan Diogo

I tried getting the date field values from jira issue as its get as string so converting to Date format. Look like my script isn't working. Could you please see what is missing.

import com.atlassian.jira.component.ComponentAccessor

import com.atlassian.jira.event.type.EventDispatchOption

import com.atlassian.jira.issue.MutableIssue

import org.apache.log4j.Category

import com.atlassian.jira.issue.IssueManager;

import java.sql.Timestamp

import com.atlassian.jira.issue.ModifiedValue

import com.atlassian.jira.issue.util.DefaultIssueChangeHolder

import com.atlassian.jira.issue.util.IssueChangeHolder

import com.atlassian.jira.issue.*

import java.util.Date

import java.text.SimpleDateFormat

import java.text.DateFormat

import java.text.ParseException

import java.sql.Timestamp

import com.atlassian.mail.Email

import com.atlassian.mail.server.MailServerManager;

import com.atlassian.mail.server.SMTPMailServer;

import com.atlassian.mail.queue.MailQueue

import com.atlassian.mail.queue.SingleMailQueueItem

import java.time.LocalDate

import java.time.format.DateTimeFormatter

 import java.text.DateFormat

////////////////////////////////////////////////////////////////////////////////////////

//Used for testing on specific issue

def IssueKey = "GT-5429"

def issue = ComponentAccessor.getIssueManager().getIssueObject(IssueKey)

////////////////////////////////////////////////////////////////////////////////////////

Calendar cal = Calendar.getInstance();

// Logger

//def Category log = Category.getInstance("com.onresolve.jira.groovy.PostFunction");

def user = ComponentAccessor.jiraAuthenticationContext.getLoggedInUser()

def IssueManager issueManager = ComponentAccessor.issueManager

IssueChangeHolder changeHolder = new DefaultIssueChangeHolder();

//MutableIssue issue = event.issue as MutableIssue

 

// Set the logging level to DEBUG

log.setLevel(org.apache.log4j.Level.DEBUG);

def cf_pirResultDate = ComponentAccessor.customFieldManager.getCustomFieldObjectsByName("PIR Results/LL Due Date").first()

def cf_impdt = ComponentAccessor.customFieldManager.getCustomFieldObjectsByName("Implementation Date").first()

def cf_datedt = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectsByName("Date").first()

// Define the list of holidays (in YYYY-MM-DD format)

def holidays = [

LocalDate.parse("2025-01-06"),

LocalDate.parse("2025-01-09")

]

String cf_impdtValue = issue.getCustomFieldValue(cf_impdt).toString()

String cf_datedtValue = issue.getCustomFieldValue(cf_datedt).toString()

def datePattern = "yyyy-MM-dd";

DateFormat formatter = new SimpleDateFormat(datePattern);

Date Startdate = formatter.parse(cf_impdtValue);

Date EndDate = formatter.parse(cf_datedtValue);

def holidaysInRange = holidays.findAll { it.isAfter(Startdate.minusDays(1)) && it.isBefore(EndDate.plusDays(1)) }

Kawan Diogo_ykfovu

Hi @Omprakash Thamsetty

You need to convert the Date to LocalDate to make the correct comparison with the holidays. Additionally, I recommend adding some logs to ensure every field is set with a value.

Here’s a new version with these adjustments. Please try it and let me know if it works.

import com.atlassian.jira.component.ComponentAccessor
import org.apache.log4j.Category
import java.text.SimpleDateFormat
import java.util.Date
import java.time.LocalDate

// Logger
def log = Category.getInstance("com.onresolve.jira.groovy.PostFunction");
log.setLevel(org.apache.log4j.Level.DEBUG);

// Issue Key for testing
def IssueKey = "GT-5429"
def issue = ComponentAccessor.getIssueManager().getIssueObject(IssueKey)

if (!issue) {
log.error("Issue not found.");
return;
}

// Custom fields
def cf_impdt = ComponentAccessor.customFieldManager.getCustomFieldObjectsByName("Implementation Date")?.first()
def cf_datedt = ComponentAccessor.customFieldManager.getCustomFieldObjectsByName("Date")?.first()

if (!cf_impdt || !cf_datedt) {
log.error("Required custom fields not found.");
return;
}

// Custom field values
String cf_impdtValue = issue.getCustomFieldValue(cf_impdt)?.toString()
String cf_datedtValue = issue.getCustomFieldValue(cf_datedt)?.toString()

if (!cf_impdtValue || !cf_datedtValue) {
log.error("Custom field values are null or empty.");
return;
}

// Parse dates
def datePattern = "yyyy-MM-dd";
Date Startdate, EndDate;
try {
def formatter = new SimpleDateFormat(datePattern);
Startdate = formatter.parse(cf_impdtValue);
EndDate = formatter.parse(cf_datedtValue);
} catch (Exception e) {
log.error("Error parsing dates: ${e.message}");
return;
}

// Convert Date to LocalDate
def startDate = Startdate.toInstant().atZone(java.time.ZoneId.systemDefault()).toLocalDate();
def endDate = EndDate.toInstant().atZone(java.time.ZoneId.systemDefault()).toLocalDate();

// Define holidays
def holidays = [
LocalDate.parse("2025-01-06"),
LocalDate.parse("2025-01-09")
]

// Find holidays in range
def holidaysInRange = holidays.findAll { it.isAfter(startDate.minusDays(1)) && it.isBefore(endDate.plusDays(1)) }
log.debug("Holidays in range: ${holidaysInRange}");

Omprakash Thamsetty

Hi @Kawan Diogo Yes, This worked.

I tried converting string to LocalDate but couldn't not success but your code works fine.

Looks tome I am good with this now. Thank you so much.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

scriptrunner

jira

jira-server

jira-data-center

data-center