Versions Compared

Old Version 9

changes.mady.by.user Radhika Vijji.

Saved on

compared with

New Version 10

changes.mady.by.user Radhika Vijji.

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...

Code Block
languagejs
linenumberstrue
{% 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#-Return the Momentjs#}
    {{-from | date}}   
{% endmacro -%}

{{% call add(<from>, <nod>) -%}
{%- endcall %}

Placeholders

Placeholder

Description

Example

<from>Date to which the number of days should be addednew Date()
<nod>Number of days to add22


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
      languagejs
      linenumberstrue
      {% 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#-Return the Momentjs#}
    {{-from | date}}   
{% endmacro -%}

{{% call add(issue.fields.created, 5) -%}
{%- endcall %}


  • 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
      languagejs
      linenumberstrue
      {% 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#-Return the Momentjs#}
    {{-from | date}}  

{% endmacro -%}

{% call add(now, 6) -%}
Your issue will be resolved on or before: {%- endcall %{{add(now,6)}}


References

...