Our new Appfire Documentation Space is now live!

Take a look here! If you have any questions please email support@appfire.com

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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
  • Before adding the remaining days, skip the start if it is a weekend
  • 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 weeks = weeks | int %}
	{% set remDays = nod%5 %}

	{# Adding the whole weeks #}
	{% set from = from | date('add', weeks,'weeks') %}

	{# Skipping the weekend if starting with Friday #}
    {% if from | date('day') == "5" and remDays > 0 %}
		{% set from = from | date('add',1,'d') | date %}
	{% endif %}
    
    {# Skipping the starting weekend #}
	{% if from | date('day') == "6" %}
		{% set from = from | date('add',1,'d') %}
	{% endif %}

	{% if from | date('day') == "0"  and remDays == 0 %}
		{% set from = from | date('add',1,'d') %}
	{% endif %}	

	{# Add remaining days #}
	{% set from = from | date('add',remDays,'d') %}

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

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

      {% macro add(from, nod) %}
	{% set weeks = nod/5 %}
	{% set weeks = weeks | int %}
	{% set remDays = nod%5 %}

	{# Adding the whole weeks #}
	{% set from = from | date('add', weeks,'weeks') %}

	{# Skipping the weekend if starting with Friday #}
    {% if from | date('day') == "5" and remDays > 0 %}
		{% set from = from | date('add',1,'d') | date %}
	{% endif %}
    
    {# Skipping the starting weekend #}
	{% if from | date('day') == "6" %}
		{% set from = from | date('add',1,'d') %}
	{% endif %}

	{% if from | date('day') == "0"  and remDays == 0 %}
		{% set from = from | date('add',1,'d') %}
	{% endif %}	

	{# Add remaining days #}
	{% set from = from | date('add',remDays,'d') %}

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

	{{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 weeks = weeks | int %}
    {% set remDays = nod%5 %}
 
    {# Adding the whole weeks #}
    {% set from = from | date('add', weeks,'weeks') %}
 
    {# Skipping the weekend if starting with Friday #}
    {% if from | date('day') == "5" and remDays > 0 %}
        {% set from = from | date('add',1,'d') | date %}
    {% endif %}
     
    {# Skipping the starting weekend #}
    {% if from | date('day') == "6" %}
        {% set from = from | date('add',1,'d') %}
    {% endif %}
 
    {% if from | date('day') == "0"  and remDays == 0 %}
        {% set from = from | date('add',1,'d') %}
    {% endif %}
 
    {# Add remaining days #}
    {% set from = from | date('add',remDays,'d') %}
 
    {# 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 %}
 
    {{ caller() }} {{from | date}}
{% endmacro%}
 
{% call add(issue.fields.created, 5) -%}
Your issue will be resolved on/before:
{%- endcall %}{% macro add(from, nod) %}

References

  • No labels