Page Comparison

Abstract

This code snippet adds a certain number of days to a date excluding the weekends. Currently, when you add a certain number of days to a date the weekends are included. To exclude them, you can use this snippet.

...

Placeholder	Description	Example
`<from`>	Date to which the number of days should be added	`new Date()`
`<nod>`	Number of days to add	`22`

Examples

The output of the code snippet is a Moment.js date object which you could use to:

Set a Date/Date-time picker field - Eg: Set the Due date to issue created plus 5 days excluding weekends in

one of the Set Field Value post-functions

in the Create issue post-function under Set fields of new issue section

Code Block

language	js
linenumbers	true

{% macro add(from, nod) %}
	{% set weeks = nod//5 %}
	{% set remDays = nod%5 %}

	{# Adding the whole weeks #}
	{% set from = from | date('add', weeks,'weeks') %}
    
	{# Run a loop and check each day to skip a weekend #}
    {% for i in range(0,remDays) %}
      {% set from = from | date('add',1,'d') | date %}
      {# Run a loop and check each day to skip a weekend #}
      {% if from | date('day') == "6" %}
          {% set from = from | date('add',1,'d') | date %}
      {% endif %}
      {% if from | date('day') == "0" %}
          {% set from = from | date('add',1,'d') | date %}
      {% endif %}
    {% endfor %}

	{# Skipping the ending weekend #}
	{% if from | date('day') == "6" %}
		{% set from = from | date('add',1,'d') %}
	{% endif %}
	{% if from | date('day') == "0" %}
		{% set from = from | date('add',1,'d') %}
	{% endif %}
	
    {#Return the Momentjs#}
    {{from | date}}   
{% endmacro -%}
{{add(issue.fields.created, 5)}}

Notify the customer that the issue will be resolved in 6 days from today through the

Comment in one of the Comment issue post-functions

Subject/HTML body/Text body of Email issue post-function

Code Block

language	js
linenumbers	true

{% macro add(from, nod) %}
	{% set weeks = nod//5 %}
	{% set remDays = nod%5 %}

	{# Adding the whole weeks #}
	{% set from = from | date('add', weeks,'weeks') %}
    
	{# Run a loop and check each day to skip a weekend #}
    {% for i in range(0,remDays) %}
      {% set from = from | date('add',1,'d') | date %}
      {# Run a loop and check each day to skip a weekend #}
      {% if from | date('day') == "6" %}
          {% set from = from | date('add',1,'d') | date %}
      {% endif %}
      {% if from | date('day') == "0" %}
          {% set from = from | date('add',1,'d') | date %}
      {% endif %}
    {% endfor %}

	{# Skipping the ending weekend #}
	{% if from | date('day') == "6" %}
		{% set from = from | date('add',1,'d') %}
	{% endif %}
	{% if from | date('day') == "0" %}
		{% set from = from | date('add',1,'d') %}
	{% endif %}
	
    {#Return the Momentjs#}
    {{from | date}}   
{% endmacro -%}
Your issue will be resolved on or before: {{add(now, 6)}}

...

Versions Compared

Old Version 7

New Version 8

Key

Abstract