...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
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.
...
- 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
| 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 %}
{# 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 %}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'5 ) | 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
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('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 %} {# 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 %}
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) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...