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 %}
    {% 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(<from>,<nod>)-}}

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

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

Our new Appfire Documentation Space is now live!

Abstract

Logic

Snippet

Placeholders

References

Related articles

Filter by label