{"id":114717,"date":"2021-10-05T16:56:59","date_gmt":"2021-10-05T07:56:59","guid":{"rendered":"https:\/\/support.questetra.com\/?p=114717"},"modified":"2023-08-22T15:15:12","modified_gmt":"2023-08-22T06:15:12","slug":"date-calc-after-n-business-days-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/date-calc-after-n-business-days-2021\/","title":{"rendered":"#Date: Calc after N Business Days"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Date, Calc after N Business Days<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Calculates N business days after the specified date. If N is negative, returns N business days ago. It is necessary to set a holiday in advance. It is also possible to add company-original holidays.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> A1: Set All Holidays in each line (&#8220;2021-12-25,Christmas&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> B1: Set Days of Week to be Closed (eg &#8220;0,Sun&#8221; )<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> B2: Set Special Days that not be closed (&#8220;2022-04-01&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C1: Set Date\/Datetime of Start (eg &#8220;2022-04-29&#8221; )<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C2: Set Number of Days to Add (eg &#8220;3&#8221; &#8220;-2&#8221; )<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> D1: Select DATE DATA that stores Calced Date (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> D2: Select STRING DATA that stores Non-business Days (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strHolidays     = configs.get( &quot;StrConfA1&quot; );        \/\/ NotRequired \/\/\/\/\/\/\/\/\/\/\/\n  if( strHolidays   === &quot;&quot; ){\n    engine.log( &quot; AutomatedTask ConfigWarning:&quot; +\n                &quot; Config {A1: Holidays} is empty&quot; );\n  }\n  let arr2dHolidays   = parseTwoColOfCsv( strHolidays );\nconst strClosedDays   = configs.get( &quot;StrConfB1&quot; );        \/\/ NotRequired \/\/\/\/\/\/\/\/\/\/\/\n  if( strClosedDays === &quot;&quot; ){\n    engine.log( &quot; AutomatedTask ConfigWarning:&quot; +\n                &quot; Config {B1: Closed DaysOfWeek} is empty&quot; );\n  }\n  let arr2dClosedDays = parseTwoColOfCsv( strClosedDays );\nconst strOpenDespiteWeekends = configs.get( &quot;StrConfB2&quot; ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\/\/\n  let arrOpenDespiteWeekends = strOpenDespiteWeekends.split(&quot;\\n&quot;);\nconst strTarget       = configs.get( &quot;StrConfC1&quot; );        \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\n  if( strTarget     === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {C1: Date or Datetime} is empty \\n&quot; );\n  }\n  let dateTarget      = parseDateAsMidnight( strTarget ); \/\/ the first of the date\nconst strToAdd        = configs.get( &quot;StrConfC2&quot; );        \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\n  let numToAdd        = parseInt( strToAdd );\n  if( isNaN( numToAdd ) ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {C2} is not an integer \\n&quot; );\n  }\nconst datePocketOutput = configs.getObject( &quot;SelectConfD1&quot; ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\nconst strPocketNonbiz  = configs.getObject( &quot;SelectConfD2&quot; ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\/\/\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nif( numToAdd === 0 ){\n  engine.log( &quot; AutomatedTask ConfigWarning:&quot; +\n              &quot; Config {C2} is Zero, Not calculated&quot; );\n  engine.setData( datePocketOutput, new java.sql.Date( dateTarget.getTime() ) );\n  return;\n}\n\n\nDate.prototype.toBpmsYMD = function() {\n  var dd = this.getDate(); var mm = this.getMonth() + 1; \/\/ getMonth() is zero-based\n  return [ this.getFullYear(), (mm&gt;9 ? &#39;&#39; : &#39;0&#39;) + mm, (dd&gt;9 ? &#39;&#39; : &#39;0&#39;) + dd ].join(&#39;-&#39;);\n};\nlet n = 0;\nlet strNonbiz = &quot;&quot;;\n\nwhile( n !== numToAdd ){\n  if( numToAdd &lt; 0 ){ dateTarget.setDate( dateTarget.getDate() - 1 ); }\n  if( numToAdd &gt; 0 ){ dateTarget.setDate( dateTarget.getDate() + 1 ); }\n  engine.log( &quot; AutomatedTask RuntimeLog:&quot; +\n              &quot; DayOfWeek of &quot; + dateTarget.toBpmsYMD() + &quot; (Sun=0,Mon=1): &quot; + dateTarget.getDay() );\n\n  let strOutput = &quot;&quot;;\n  for( let i = 0; i &lt; arr2dHolidays.length; i++ ){\n    let dateTmp = parseDateAsMidnight( arr2dHolidays[i][0] ); \/\/ the first of the date, &quot;00:00&quot;\n    if( dateTmp.getTime() === dateTarget.getTime() ){\n      strOutput = arr2dHolidays[i][1];\n      break;\n    }\n  }\n  if( strOutput !== &quot;&quot; ){\n    engine.log( &quot; AutomatedTask RuntimeLog:&quot; +\n                &quot; Holiday&quot; );\n  }else{\n    engine.log( &quot; AutomatedTask RuntimeLog:&quot; +\n                &quot; Not holiday&quot; );\n    for( let i = 0; i &lt; arr2dClosedDays.length; i++ ){\n      if( arr2dClosedDays[i][0] === dateTarget.getDay() + &quot;&quot; ){ \/\/ Matches Closing Day\n        engine.log( &quot; AutomatedTask RuntimeLog: &quot; +\n                    arr2dClosedDays[i][1] );\n        let boolOpen = false;\n        if( strOpenDespiteWeekends !== &quot;&quot; ){\n          for( let j = 0; j &lt; arrOpenDespiteWeekends.length; j++ ){\n            let dateTmp = parseDateAsMidnight( arrOpenDespiteWeekends[j] );\n            if( dateTmp.getTime() === dateTarget.getTime() ){\n              boolOpen = true;\n              break;\n            }\n          }\n        }\n        if( ! boolOpen ){\n          strOutput = arr2dClosedDays[i][1];\n        }else{\n          engine.log( &quot; AutomatedTask RuntimeLog:&quot; +\n                      &quot; but be Open despite &quot; + arr2dClosedDays[i][1] );\n        }\n        break;\n      }\n    }\n  }\n\n  if( numToAdd &lt; 0 ){\n    if( strOutput === &quot;&quot; ){\n      n = n - 1;\n    }else{\n      strNonbiz += dateTarget.toBpmsYMD() + &quot;\\t&quot; + strOutput + &quot;\\n&quot;;\n    }\n  }\n  if( numToAdd &gt; 0 ){\n    if( strOutput === &quot;&quot; ){\n      n = n + 1;\n    }else{\n      strNonbiz += dateTarget.toBpmsYMD() + &quot;\\t&quot; + strOutput + &quot;\\n&quot;;\n    }\n  }\n} \/\/ end of while\n\nif( strNonbiz !== &quot;&quot; ){\n  strNonbiz = strNonbiz.slice( 0, -1 ); \/\/ delete last &quot;\\n&quot;\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( datePocketOutput, new java.sql.Date( dateTarget.getTime() ) );\nif( strPocketNonbiz !== null ){\n  engine.setData( strPocketNonbiz, strNonbiz );\n}\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\nfunction parseDateAsMidnight( str ) { \/\/ Transform date from String to Date\n  if( str === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ParseDateError:&quot; +\n                     &quot; String is empty \\n&quot; );\n  }\n  var arrNumParts = str.match( \/\\d+\/g );\n  if( arrNumParts === null ){\n    throw new Error( &quot;\\n AutomatedTask ParseDateError:&quot; +\n                     &quot; No numeric characters in: &quot; + str + &quot;\\n&quot; );\n  }\n  if( arrNumParts.length &lt; 3){\n    throw new Error( &quot;\\n AutomatedTask ParseDateError:&quot; +\n                     &quot; 3 Parts of numeric characters are needed in: &quot; + str + &quot;\\n&quot; );\n  }\n  return new Date( parseInt(arrNumParts[0], 10), \n                   parseInt(arrNumParts[1], 10) - 1, \n                   parseInt(arrNumParts[2], 10) ); \/\/ months are 0-based\n  \/\/ Note: new Date(&quot;2014-11-10&quot;) \/\/ Mon Nov 10 2014 09:00:00 GMT+0900 (JST)\n  \/\/ Note: new Date(2014, 10, 10) \/\/ Mon Nov 10 2014 00:00:00 GMT+0900 (JST)\n}\n\n\/\/ Parses CSV string and Creates a 2D array.\nfunction parseTwoColOfCsv( strCsv ){\n  const arrCsv = strCsv.split(&quot;\\n&quot;);\n  let arr2d    = [];\n  for( let i = 0; i &lt; arrCsv.length; i++ ){\n    if( arrCsv[i] === &quot;&quot; ){ continue; } \/\/ Skip blank lines\n    let arrTmp = [];\n    let arrCells = arrCsv[i].split(&quot;,&quot;);\n    for( let j = 0; j &lt; arrCells.length; j++ ){\n      arrTmp[0] = arrCells[0];\n      arrTmp[1] = arrCells[1];\n      \/\/ Refer to only the first two columns of CSV.\n    }\n    arr2d.push( arrTmp );\n  }\n  return arr2d;\n}\n\/*\n\nNotes:\n- When the process reaches the automated task, N business days after the DATE data is automatically calculated.\n    - `YYYY-MM-DD` (date type format), `YYYY\/MM\/DD`, etc.\n    - `YYYY-MM-DD hh:mm` (datetime data format) can also be regarded as the starting date.\n- If it corresponds to &quot;A1. Holiday list&quot; of the config value, the name of the holiday is stored.\n    - You need to list all the holidays of all years.\n        - It is also possible to add &quot;company-defined holidays&quot; to the holiday list.\n    - The CSV file in the Cabinet Office &quot;About National Holidays&quot; is useful. (JAPAN)\n        - https:\/\/www8.cao.go.jp\/chosei\/shukujitsu\/gaiyou.html\n        - https:\/\/www8.cao.go.jp\/chosei\/shukujitsu\/syukujitsu.csv\n        - 2022\/1\/1,New Year&#39;s Day 2022\/1\/10,Coming-of-Age Day 2022\/2\/11,National Foundation Day 2022\/2\/23,Emperor&#39;s Birthday\n- If the config value &quot;B1. Regular closing days&quot; is applicable, the day name is stored.\n    - However, if it corresponds to &quot;a day that is not closed specially&quot;, an empty string will be stored.\n    - Set the regular holidays with a number from 0-6. (Sunday-Saturday: 0-6)\n    - If it falls on a national holiday, it will not be judged whether it is a regular closing day.\n- The starting date is not subject to holiday judgment.\n\nAPPENDIX:\n- Refers to only the first two columns of CSV.\n    - No error will occur even if the memo is written in the third column.\n    - (1st row, 2nd row, remarks memo)\n- No problem if the data is for holidays of about 50 years (about 1000 lines).\n    - If you set a large number of &quot;A1. Holiday list&quot; that exceeds 10,000 lines, an error may occur.\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u65e5\u4ed8\u30c7\u30fc\u30bf\u306eN\u55b6\u696d\u65e5\u5f8c\u304c\u81ea\u52d5\u8a08\u7b97\u3055\u308c\u307e\u3059\u3002\n    - `YYYY-MM-DD` (\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\u306e\u66f8\u5f0f) \u3084 `YYYY\/MM\/DD` \u306a\u3069\n    - `YYYY-MM-DD hh:mm` (\u65e5\u6642\u578b\u30c7\u30fc\u30bf\u306e\u66f8\u5f0f) \u3082\u8d77\u70b9\u65e5\u3068\u898b\u306a\u3059\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002\n- \u30b3\u30f3\u30d5\u30a3\u30b0\u5024\u306e\u300cA1.\u795d\u796d\u65e5\u30ea\u30b9\u30c8\u300d\u306b\u8a72\u5f53\u3059\u308b\u5834\u5408\u306b\u3001\u795d\u796d\u65e5\u306e\u540d\u524d\u304c\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\n    - \u5168\u3066\u306e\u5e74\u306e\u5168\u3066\u306e\u795d\u796d\u65e5\u3092\u30ea\u30b9\u30c8\u30a2\u30c3\u30d7\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\uff08\u5b9f\u52d9\u4e0a\u5fc5\u8981\u3068\u3055\u308c\u308b\u7bc4\u56f2\uff09\n        - \u795d\u796d\u65e5\u30ea\u30b9\u30c8\u306b\u300c\u4f1a\u793e\u304c\u5b9a\u3081\u305f\u4f11\u65e5\u300d\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\n    - \u5185\u95a3\u5e9c\u300c\u56fd\u6c11\u306e\u795d\u65e5\u306b\u3064\u3044\u3066\u300d\u306b\u3042\u308bCSV\u30d5\u30a1\u30a4\u30eb\u304c\u6709\u7528\u3067\u3059\u3002\n        - https:\/\/www8.cao.go.jp\/chosei\/shukujitsu\/gaiyou.html\n        - https:\/\/www8.cao.go.jp\/chosei\/shukujitsu\/syukujitsu.csv\n        - 2022\/1\/1,\u5143\u65e5 2022\/1\/10,\u6210\u4eba\u306e\u65e5 2022\/2\/11,\u5efa\u56fd\u8a18\u5ff5\u306e\u65e5 2022\/2\/23,\u5929\u7687\u8a95\u751f\u65e5\n- \u30b3\u30f3\u30d5\u30a3\u30b0\u5024\u300cB1.\u5b9a\u4f11\u65e5\uff08\u4f11\u696d\u3059\u308b\u66dc\u65e5\uff09\u300d\u306b\u8a72\u5f53\u3059\u308b\u5834\u5408\u306b\u3001\u66dc\u65e5\u540d\u304c\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\n    - \u305f\u3060\u3057\u300c\u7279\u5225\u306b\u4f11\u696d\u3068\u3057\u306a\u3044\u65e5\u300d\u306b\u8a72\u5f53\u3057\u305f\u5834\u5408\u306b\u306f\u3001\u7a7a\u6587\u5b57\u304c\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\n    - \u5b9a\u4f11\u66dc\u65e5\u306f 0-6 \u306e\u6570\u5b57\u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002\uff08Sunday - Saturday : 0 - 6\uff09\n    - \u795d\u796d\u65e5\u306b\u8a72\u5f53\u3059\u308b\u5834\u5408\u3001\u5b9a\u4f11\u65e5\u5224\u5b9a\u306f\u884c\u308f\u308c\u307e\u305b\u3093\u3002\n- \u8d77\u70b9\u65e5\u306f\u795d\u65e5\u5224\u5b9a\u306e\u5bfe\u8c61\u306b\u306f\u306a\u308a\u307e\u305b\u3093\u3002\n\nAPPENDIX-ja:\n- CSV\u8a2d\u5b9a\u306f\u3001\u5148\u982d\u306e2\u5217\u3060\u3051\u304c\u53c2\u7167\u3055\u308c\u307e\u3059\u3002\n    - 3\u5217\u76ee\u306b\u30e1\u30e2\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u3066\u3082\u30a8\u30e9\u30fc\u306b\u306f\u306a\u308a\u307e\u305b\u3093\n    - \uff081\u5217\u76ee,2\u5217\u76ee,\u5099\u8003\u30e1\u30e2\uff09\n- 50\u5e74\u7a0b\u5ea6\u306e\u795d\u796d\u65e5\u30c7\u30fc\u30bf\uff081000\u884c\u7a0b\u5ea6\uff09\u3067\u3042\u308c\u3070\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002\n    - 1\u4e07\u884c\u3092\u8d85\u3048\u308b\u3088\u3046\u306a\u5927\u91cf\u306e\u300cA1.\u795d\u796d\u65e5\u30ea\u30b9\u30c8\u300d\u3092\u8a2d\u5b9a\u3059\u308b\u3068\u30a8\u30e9\u30fc\u3068\u306a\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAA5JJREFUWEfF\nl1tIFGEUgL9Zc9VM7EJ2MSMpoyyii2aFpNFTPUQUREU+VMSuEpRY+FjgS4JUBNUamFBRD5FBEN0p\nUswgShEsKrqu6QbuauXa2rYT\/2yTs7OzOttm+z8O55z\/O+c\/t5GI85FM31\/LWGQ2IbEGmSVIzAIm\n\/Nb3IPMOiWfI3EeiARteM7ZHBqhnKoNUAnYg2YxR4DvgwEo1O+keTmd4AAd2JGqAVJMX68X6kTmA\nHUck\/cgAtZwCSv\/yYr3aaWyUGdkyBnBwEYlt\/+jyoBmZS9jZrrcZDmDgef7kfOqK6rjjvENFS4Vi\nY276XM6tOUe7u509D\/f8sdu0oYlP3k9subvFiD8sEqEAwTc\/rdWckTqDwqmF1Kyo4V7nPW45b5Eg\nJZCckMyhZYd42feSM8\/PkGhJxOv3UpVfRZe3i8NPDtPY3RgOIVOqzYkhgGC2v9YmXFVeFRWLKmhz\nt5GVmsX7b+\/Jm5yH1WLlzZc3JCUk4RpwkZOeQ1piGp39nfh++uge6CY7LZvBwCCljaXc+HhDC9KP\nlTlqdQwB1HIM2K9KrstaR31xPVNSpigeCc8zx2ayNnMtFsnC54HPPOh6QJIlifUz1ysR6Bvs4+bH\nm0iSxMZZGxVQEYXV11brI3EcG+XiYxBANBno0dZ5SU4JJwtPKp7Fcjo8HSy4vEBvQvSJSaJZBQEc\n7EDivFZqlAFEVZRg54IagTpgl1HyidDGctw+N9c\/XDcycRYbu9UIPEViiVZq6+ytHF15lHGJ42K5\nnxe9L1h+dblRNTzDzlI1Am7NYFGER\/0JwIONiSqArEf8DwBgQ4oawNnvpPJxpdIHjhQcoWhaEW09\nbRx8fJATq04wb\/y8EF8iVEFQRgNg+gk8Pg9+2U+vr5eGtw2ULyrnkesRV95ewT7fTu6EXLMAmidw\nEJaEwz3Bq75X7Gvep7TigowCpeNVt1azOXuzeQCZkCQMK8PhAPwBvzIDRNfbu3Cv4nHUABBShqYb\nUbOrmdaeVqXXi0iU5ZYRIBA9gK4RmW7FItwtrhZELhRPLybdmk5ADih5IIZSRkqGmRzQteLgPAgZ\nRqNchrphJAB041g7DWNphQbTMMI4Dg6lkIVE3QdSxqT8FYPYH8L2gYgLiXqFbiUTdb140mJlC4rm\niO3otvM2X3981aqNsJKponFdSiNEIhrvDWSjXMuHIhHHHxMVIq6\/ZtpYxu3nNMbHH0n9F0u2nDBH\n85JUAAAAAElFTkSuQmCC\n\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1vB09n0kp7lw2wmicHOf_Opj9dFUpv4e2\/view?usp=drivesdk\" target=\"_blank\">date-calc-after-n-business-days-2021.xml<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1Q_FByyxOVmIu4KPrpIVYVwX-YvB2uQ-2\/view?usp=sharing\" data-type=\"link\" data-id=\"https:\/\/drive.google.com\/file\/d\/1Q_FByyxOVmIu4KPrpIVYVwX-YvB2uQ-2\/view?usp=sharing\">date-calc-after-n-business-days-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for &#8220;GraalJS standard (engine-type 3)&#8221; on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-10-04 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/date-calc-after-n-business-days-2021\/\">https:\/\/support.questetra.com\/addons\/date-calc-after-n-business-days-2021\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Add-on import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<br>Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When the process reaches the automated task, N business days after the DATE data is automatically calculated.\n<ul class=\"wp-block-list\">\n<li><code>YYYY-MM-DD<\/code> (date type format), <code>YYYY\/MM\/DD<\/code>, etc.<\/li>\n\n\n\n<li><code>YYYY-MM-DD hh:mm<\/code> (datetime data format) can also be regarded as the starting date.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If it corresponds to &#8220;A1. Holiday list&#8221; of the config value, the name of the holiday is stored.\n<ul class=\"wp-block-list\">\n<li>You need to list all the holidays of all years.\n<ul class=\"wp-block-list\">\n<li>It is also possible to add company-defined holidays to the holiday list.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The CSV file in the Cabinet Office &#8220;About National Holidays&#8221; is useful. (JAPAN)\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www8.cao.go.jp\/chosei\/shukujitsu\/gaiyou.html\" rel=\"nofollow\">https:\/\/www8.cao.go.jp\/chosei\/shukujitsu\/gaiyou.html<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www8.cao.go.jp\/chosei\/shukujitsu\/syukujitsu.csv\" rel=\"nofollow\">https:\/\/www8.cao.go.jp\/chosei\/shukujitsu\/syukujitsu.csv<\/a><\/li>\n\n\n\n<li>2022\/1\/1,New Year&#8217;s Day 2022\/1\/10,Coming-of-Age Day 2022\/2\/11,National Foundation Day 2022\/2\/23,Emperor&#8217;s Birthday<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If the config value &#8220;B1. Regular closing days&#8221; is applicable, the day name is stored.\n<ul class=\"wp-block-list\">\n<li>However, if the day falls on a day that is not a special holiday an empty string will be stored.<\/li>\n\n\n\n<li>Set the regular holidays with a number from 0-6. (Sunday-Saturday: 0-6)<\/li>\n\n\n\n<li>If it falls on a national holiday, it will not be judged whether it is a regular closing day.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The starting date is not subject to holiday judgment.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"114705\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/date-calc-after-n-business-days-2021-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"date-calc-after-n-business-days-2021-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Calculates N business days after the specified date. If N is negative, returns N business days ago. It is necessary to set a holiday in advance. It is also possible to add company-original holidays.\" class=\"wp-image-114705\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default q-box\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"612\" height=\"630\" data-attachment-id=\"114709\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/date-calc-after-n-business-days-2021-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-config-en.png?fit=1193%2C1229&amp;ssl=1\" data-orig-size=\"1193,1229\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"date-calc-after-n-business-days-2021-config-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-config-en.png?fit=612%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-config-en-612x630.png?resize=612%2C630&#038;ssl=1\" alt=\"Calculates N business days after the specified date. If N is negative, returns N business days ago. It is necessary to set a holiday in advance. It is also possible to add company-original holidays.\" class=\"wp-image-114709\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-config-en.png?resize=612%2C630&amp;ssl=1 612w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-config-en.png?resize=306%2C315&amp;ssl=1 306w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-config-en.png?resize=768%2C791&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-config-en.png?w=1193&amp;ssl=1 1193w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Refers to only the first two columns of CSV.\n<ul class=\"wp-block-list\">\n<li>No error will occur even if the memo is written in the third column.<\/li>\n\n\n\n<li>(1st row, 2nd row, remarks memo)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>No problem if the data is for holidays of about 50 years (about 1000 lines).\n<ul class=\"wp-block-list\">\n<li>If you set a large number of &#8220;A1. Holiday list&#8221; that exceeds 10,000 lines, an error may occur.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"3znt9XRCHj\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/date-determine-whether-business-day-2021\/\">#Date: Determine Whether Business Day<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;#Date: Determine Whether Business Day&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/date-determine-whether-business-day-2021\/embed\/#?secret=yC3LcEWeKn#?secret=3znt9XRCHj\" data-secret=\"3znt9XRCHj\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"3cDEdseO68\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/date-get-weekend-sunday-2021\/\">#Date: Get Weekend Sunday<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;#Date: Get Weekend Sunday&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/date-get-weekend-sunday-2021\/embed\/#?secret=04eInRqVYA#?secret=3cDEdseO68\" data-secret=\"3cDEdseO68\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Calculates N business days after the specified date. If N is negative, returns N business days ago. It is necessary to set a holiday in advance. It is also possible to add company-original holidays.<\/p>\n","protected":false},"author":2,"featured_media":114713,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Calculates N business days after the specified date. If N is negative, returns N business days ago. It is necessary to set a holiday in advance. It is also possible to add company-original holidays.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[485,382,491,494],"class_list":["post-114717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-approval-flows","tag-date","tag-expense-claim","tag-routine-report"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":1,"uagb_excerpt":"Calculates N business days after the specified date. If N is negative, returns N business days ago. It is necessary to set a holiday in advance. It is also possible to add company-original holidays.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-tQh","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":140981,"url":"https:\/\/support.questetra.com\/en\/addons\/two-dates-calculate-duration-exclude-close-days-202301\/","url_meta":{"origin":114717,"position":0},"title":"Two Dates, Calculate Business Days","author":"furuzo","date":"2023-01-12","format":false,"excerpt":"Calculates the number of business days between date A and date B. Holidays must be set in advance. Company's original holidays can be added. For example, this function can be used for calculating the number of business days for the month in advance and planning the work.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/two-dates-calculate-duration-exclude-close-days-202301-en.png?fit=1200%2C630&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/two-dates-calculate-duration-exclude-close-days-202301-en.png?fit=1200%2C630&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/two-dates-calculate-duration-exclude-close-days-202301-en.png?fit=1200%2C630&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/two-dates-calculate-duration-exclude-close-days-202301-en.png?fit=1200%2C630&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/two-dates-calculate-duration-exclude-close-days-202301-en.png?fit=1200%2C630&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":114737,"url":"https:\/\/support.questetra.com\/ja\/addons\/date-calc-after-n-business-days-2021\/","url_meta":{"origin":114717,"position":1},"title":"#\u65e5\u4ed8: N\u55b6\u696d\u65e5\u5f8c\u306e\u7b97\u51fa","author":"IMAMURA, Genichi","date":"2021-10-05","format":false,"excerpt":"\u4efb\u610f\u65e5\u4ed8\u306eN\u55b6\u696d\u65e5\u5f8c\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002N\u304c\u30de\u30a4\u30ca\u30b9\u306e\u5834\u5408\u3001N\u55b6\u696d\u65e5\u524d\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002\u3042\u3089\u304b\u3058\u3081\u795d\u796d\u65e5\u306e\u8a2d\u5b9a\u304c\u5fc5\u8981\u3067\u3059\u3002\u4f1a\u793e\u30aa\u30ea\u30b8\u30ca\u30eb\u306e\u4f11\u65e5\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u65e5\u4ed8, N\u55b6\u696d\u65e5\u5f8c\u306e\u7b97\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-calc-after-n-business-days-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":137668,"url":"https:\/\/support.questetra.com\/en\/addons\/two-dates-calculate-duration-exclude-close-days-202209\/","url_meta":{"origin":114717,"position":2},"title":"Two Dates, Calculate Business Days","author":"furuzo","date":"2022-10-12","format":false,"excerpt":"Calculates Business Day Count between datetime A and B to output as numerical value (days).","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?fit=1200%2C630&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?fit=1200%2C630&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?fit=1200%2C630&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?fit=1200%2C630&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?fit=1200%2C630&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":114674,"url":"https:\/\/support.questetra.com\/en\/addons\/date-determine-whether-business-day-2021\/","url_meta":{"origin":114717,"position":3},"title":"#Date: Determine Whether Business Day","author":"IMAMURA, Genichi","date":"2021-10-05","format":false,"excerpt":"Determines whether the date value is Business Day or not. If holiday, returns the name of holiday. If Sat or Sun, returns the day name. Otherwise, returns an empty string. You can also set special holidays set by your company.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Date, Determine Whether Business Day","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":87847,"url":"https:\/\/support.questetra.com\/en\/addons\/string-extract-substring\/","url_meta":{"origin":114717,"position":4},"title":"String, Extract Substring","author":"IMAMURA, Genichi","date":"2021-02-01","format":false,"excerpt":"Extracts N characters from the beginning. If negative, N characters (absolute value) are extracted from the end. When the length of the original string is shorter than N, returns the original. To be padded to N, set the pad string.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"String, Extract Substring","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/String-Extract-Substring-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/String-Extract-Substring-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/String-Extract-Substring-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/String-Extract-Substring-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/String-Extract-Substring-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":78739,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/receive-task-webhook\/","url_meta":{"origin":114717,"position":5},"title":"Receive Task (Webhook)","author":"Hirotaka NISHI","date":"2019-10-01","format":false,"excerpt":"Holds the token and awaits a webhook (HTTP request) at a specific URL. Advances the token when a webhook for the specified HTTP method is received. Capable of storing the received request body in a String-type Data Item. Also possible to return an HTTP response with Business Data inserted.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-receive-task-webhook-1200x675.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-receive-task-webhook-1200x675.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-receive-task-webhook-1200x675.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-receive-task-webhook-1200x675.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-receive-task-webhook-1200x675.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/114717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=114717"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/114717\/revisions"}],"predecessor-version":[{"id":149941,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/114717\/revisions\/149941"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/114713"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=114717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=114717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=114717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}