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
...
...
Snippet
| Code Block | ||||
|---|---|---|---|---|
| ||||
{% macro add(from, nod) %}
{% set weeks = nod//5 %}
{% set remDays = nod%5 %}
{#- Adding the whole weeks #}
{%- set from = from <fromDate> | 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>)}}businessAdd', <nod> ) | date }} |
Placeholders
Placeholder | Description | Example |
|---|---|---|
<from<fromDate> | Date to which the number of days should be added | new Date()now |
<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 issue.fields.duedate | date('addbusinessAdd', 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)}} 5 ) | date }}
- 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 {%Your macro add(from, nod) %} {% set weeks = nod//5 %} {% set remDays = nod%5 %} {#- Adding the whole weeks #} {%- set from = from issue will be resolved on or before: {{ issue.fields.created | 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)businessAdd', 6 ) | date }}
References
- How to insert information using Nunjucks annotations
- Accessing JIRA Standard fields
- now variable
- Date filter
- businessAdd filter
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...