Add a certain number of days to a date excluding the weekends - Nunjucks

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.

Logic

Fetch the number of days to be added and first add the whole weeks
Run a loop to add a day each until the number of remaining days - Skip if the day is a "Saturday" or a "Sunday"
After adding the days, skip the end if it is a weekend
Return the Momentjs

Snippet

{% 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 -%}

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

Placeholders

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

{% 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 -%}

{% 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

{% 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 -%}

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

Our new Appfire Documentation Space is now live!

Abstract

Logic

Snippet

Placeholders

References

Related articles

Filter by label