Applying business hours to custom reports

Hi Trudy,

Currently the Release includes the number of working / non-working days and the project specifies the number of standard working days per month and working hours per day, but they are not tied to the calendar dates directly, they are aggregate. So you'd need to hard code the calculation to use 5/7 of the value, or write a custom calculation of some kind.

I'd also check the Microsoft Entity SQL Docs to see what other functions exist - https://msdn.microsoft.com/en-us/library/system.data.objects.entityfunctions.diffdays(v=vs.110).aspx

Regards

Jim

tdobbelaere , use JavaScript to calculate it at frontend.

<script type="text/javascript">
  <xsl:text disable-output-escaping="yes">
    <![CDATA[
         console.log('hello world');

function calculateBusinessDays(startDate, endDate) {
// Validate input
	let negative = false;
	if (endDate < startDate) {
		negative = true;
		[endDate, startDate] = [startDate, endDate];
	}

// Calculate days between dates
	const millisecondsPerDay = 86400 * 1000; // Day in milliseconds
	startDate.setHours(0, 0, 0, 1);  // Start just after midnight
	endDate.setHours(23, 59, 59, 999);  // End just before midnight
	let diff = endDate - startDate;  // Milliseconds between datetime objects
	let days = Math.ceil(diff / millisecondsPerDay);

// Subtract two weekend days for every week in between
	let weeks = Math.floor(days / 7);
	days = days - (weeks * 2);

// Handle special cases
	let startDay = startDate.getDay();
	let endDay = endDate.getDay();

// Remove weekend not previously removed.
	if (startDay - endDay > 1) days = days - 2;

// Remove start day if span starts on Sunday but ends before Saturday
	if (startDay === 0 && endDay !== 6) {
		days = days - 1;
	}

// Remove end day if span ends on Saturday but starts after Sunday
	if (endDay === 6 && startDay !== 0) {
		days = days - 1;
	}

	return negative ? -days : days;
}

    ]]>
  </xsl:text>
</script>