{"id":137668,"date":"2022-10-12T17:03:40","date_gmt":"2022-10-12T08:03:40","guid":{"rendered":"https:\/\/support.questetra.com\/?p=137668"},"modified":"2023-01-12T15:51:09","modified_gmt":"2023-01-12T06:51:09","slug":"two-dates-calculate-duration-exclude-close-days-202209","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/two-dates-calculate-duration-exclude-close-days-202209\/","title":{"rendered":"Two Dates, Calculate Business Days"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5dab2;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFF4CC;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/two-dates-calculate-duration-exclude-close-days-202301\/\">https:\/\/support.questetra.com\/addons\/two-dates-calculate-duration-exclude-close-days-202301\/<\/a><\/div>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">Two Dates, Calculate 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 Business Day Count between datetime A and B to output as numerical value (days). It is necessary to set holidays 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> A: Select DATE DATA<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> B: Select DATE DATA<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C: Holiday Master File Name<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-toggle-off fa-lg\"><\/i><\/span> D: Share Kind Of Holiday Master File (ON: Shared)<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> E: 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> F: Select DECIMAL DATA that stores Calced Date (update)<span style=\"color:#990000;\"> *<\/span><\/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>\nmain();\nfunction main(){\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst numDataIdA = configs.get(&quot;conf_DataIdA&quot;);\nconst numDataIdB = configs.get(&quot;conf_DataIdB&quot;);\nconst holidayMasterFileName = configs.get(&quot;conf_HolidayMasterFileName&quot;);\nconst strIsShare = configs.get(&quot;conf_IsShareHolidayMaster&quot;);\nconst closedDaysConfigs = configs.get(&quot;conf_DataIdE&quot;);\nconst numDataIdF = configs.get(&quot;conf_DataIdF&quot;);\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet startDate = engine.findDataByNumber( numDataIdA );\nlet endDate = engine.findDataByNumber( numDataIdB );\nlet strEndDate = &quot;&quot;;\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nif ( startDate === null){\nengine.log(&quot;Start Date is null. Business Day Count is zero.&quot;);\nengine.setDataByNumber( numDataIdF, new java.math.BigDecimal( 0 ) );\nreturn;\n}\nif ( endDate === null ){\nengine.log(&quot;End Date is null. Force Set Today to End Date.&quot;);\nlet now = new Date();\nendDate = java.sql.Date.valueOf(now.getFullYear() + &quot;-&quot; + (now.getMonth()+1).toString().padStart(2, &#39;0&#39;) + &quot;-&quot; + now.getDate().toString().padStart(2, &#39;0&#39;));\nengine.setDataByNumber( numDataIdB , endDate);\nnow.setDate(now.getDate() + 1 );\nstrEndDate = now.getFullYear() + &quot;-&quot; + (now.getMonth()+1).toString().padStart(2, &#39;0&#39;) + &quot;-&quot; + now.getDate().toString().padStart(2, &#39;0&#39;);\n}else{\nstrEndDate = endDate.addDays(1) + &quot;&quot;;\n}\nengine.log(&quot;strEndDate: &quot; + strEndDate);\nconst milliSecStartDate = toJsDate( startDate + &quot;&quot;).getTime();\nconst milliSecEndDate = toJsDate( strEndDate ).getTime(); \/\/ include last day\nconst milliSecDuration = milliSecEndDate - milliSecStartDate;\n\nif ( milliSecStartDate &gt;= milliSecEndDate ){\nengine.log(&quot;Start Date &gt;= End Date. Business Day Count is zero.&quot;);\nengine.setDataByNumber( numDataIdF, new java.math.BigDecimal( 0 ) );\nreturn;\n}\n\nlet excludeCount = 0;\nlet closedDays = new Array();\nif (closedDaysConfigs !== null){\nclosedDays = closedDaysConfigs.split(&quot;\\n&quot;);\n}\nengine.log(&quot;closedDays lenght: &quot; + closedDays.length);\nconst allDurationDaysCount = milliSecDuration \/1000 \/60 \/60 \/24 ;\nengine.log(&quot;All Duration Days: &quot; + allDurationDaysCount);\n\nlet isShare = true;\nif (strIsShare === &quot;false&quot;){\nisShare = false;\n}\n\/\/ Holiday Master Check\nconst holidayConfigList = itemDao.findAll( holidayMasterFileName , isShare);\nfor (let i=0; i &lt; holidayConfigList.size(); i++){\nlet config = holidayConfigList.get(i);\nlet dateObjHoriday = toJsDate( config.getValue() );\nlet milliSecHoridayDate = toJsDate( config.getValue() ).getTime();\nlet horidayName = config.getDisplay();\nif (( milliSecStartDate &lt;= milliSecHoridayDate )&&( milliSecEndDate &gt;= milliSecHoridayDate )){\nengine.log(&quot;Exclude Holiday: &quot; + config.getValue() + &quot; &quot; + horidayName);\nexcludeCount++;\n\/\/ Avoid Duplication (Holiday and Weekly Closed Day)\nfor (let j=0; j &lt; closedDays.length; j++){\nlet closedDay = closedDays[j].split(&quot;,&quot;);\nif (closedDay[0] === (dateObjHoriday.getDay() + &quot;&quot;)){\nengine.log(config.getValue() + &quot; &quot; + horidayName + &quot; &quot; + closedDay[1]);\nexcludeCount--;\nbreak;\n}\n}\n}\n}\n\/\/ &quot;Days of Week to be Closed&quot; Check\nfor (let i=0; i &lt; allDurationDaysCount; i++){\nlet dateObjTargetDate = toJsDate( startDate.addDays(i) + &quot;&quot; );\nfor (let j=0; j &lt; closedDays.length; j++){\nlet closedDay = closedDays[j].split(&quot;,&quot;);\nif (closedDay[0] === (dateObjTargetDate.getDay() + &quot;&quot;)){\nengine.log(&quot;Exclude Close Days: &quot; + (startDate.addDays(i) + &quot;&quot;));\nexcludeCount++;\nbreak;\n}\n}\n}\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.log(&quot;Exclude Count: &quot; + excludeCount);\nengine.log(&quot;Business Days Count: &quot; + (allDurationDaysCount - excludeCount));\nengine.setDataByNumber( numDataIdF , new java.math.BigDecimal(allDurationDaysCount - excludeCount) );\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nfunction toJsDate( bpmsDateOrDatetimeStr ){\n\/\/ BPMS Date: &quot;2020-04-01&quot; (subtype &quot;Y\/M&quot; &quot;M\/D&quot; &quot;Y&quot;, not supported)\n\/\/ BPMS Datetime: &quot;2020-04-01 23:59&quot;\nlet year = 0;\nlet monthIndex = 0;\nlet day = 0;\nlet hours = 0;\nlet minutes = 0;\n\n\/\/ The ECMA\/JavaScript Date object has a large number of methods.\n\/\/ &quot;Date.parse&quot; is danger (strongly discouraged)\n\/\/ - new Date(&quot;2014-11-10&quot;) \/\/ Mon Nov 10 2014 09:00:00 GMT+0900 (JST)\n\/\/ - new Date(2014, 10, 10) \/\/ Mon Nov 10 2014 00:00:00 GMT+0900 (JST)\nlet arrDatetime = bpmsDateOrDatetimeStr.split(&quot; &quot;);\nif( arrDatetime.length === 1 ){\nlet arrDateParts = arrDatetime[0].split(&quot;-&quot;);\nyear = parseInt(arrDateParts[0], 10);\nmonthIndex = parseInt(arrDateParts[1], 10) - 1;\nday = parseInt(arrDateParts[2], 10);\n}\nif( arrDatetime.length === 2 ){\nlet arrDateParts = arrDatetime[0].split(&quot;-&quot;);\nlet arrTimeParts = arrDatetime[1].split(&quot;:&quot;);\nyear = parseInt(arrDateParts[0], 10);\nmonthIndex = parseInt(arrDateParts[1], 10) - 1;\nday = parseInt(arrDateParts[2], 10);\nhours = parseInt(arrTimeParts[0], 10);\nminutes = parseInt(arrTimeParts[1], 10);\n}\nreturn new Date( year, monthIndex, day, hours, minutes );\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 href=\"https:\/\/drive.google.com\/file\/d\/1yYTd7cpUF68T8AgF7pT7Hc1z72w-RlSN\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">two-dates-calculate-duration-exclude-close-days-202209.xml<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2022-09-09 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/two-dates-calculate-duration-exclude-close-days-202209\/\">https:\/\/support.questetra.com\/addons\/services\/two-dates-calculate-duration-exclude-close-days-202209\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Addon-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>Period of Calculating Business Days\n<ul class=\"wp-block-list\">\n<li>Between &#8220;A:&#8221; Data Item (Date Type) and &#8220;B:&#8221; Data Item (Date Type). Include days (&#8220;A:&#8221;,&#8221;B:&#8221; day).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>&#8220;D: Share Kind Of Holiday Master File (ON: Shared)&#8221;\n<ul class=\"wp-block-list\">\n<li>&#8220;C:&#8221; Master file of Select type Data Item [ON] App-shared Add-on file , [OFF] Add-on file<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>&#8220;A:&#8221; Data Item is Null\n<ul class=\"wp-block-list\">\n<li>Business Days is &#8220;0&#8221;.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Holiday and Closed Day are the same\n<ul class=\"wp-block-list\">\n<li>Count as one day.<\/li>\n<\/ul>\n<\/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-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" data-comments-opened=\"0\" data-image-title=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%BC%E3%83%B3%E3%82%B7%E3%83%A7%E3%83%83%E3%83%88-2022-10-12-165925.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/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>&#8220;C:&#8221; Holiday Master File (example: Japanese Holiday)<\/li>\n<\/ul>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-html\" data-file=\"holiday-master.xml\" data-lang=\"HTML\"><code>&lt;items&gt;\n&lt;item value=&quot;2022-01-01&quot; display=&quot;\u5143\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-01-10&quot; display=&quot;\u6210\u4eba\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-02-11&quot; display=&quot;\u5efa\u56fd\u8a18\u5ff5\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-02-23&quot; display=&quot;\u5929\u7687\u8a95\u751f\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-03-21&quot; display=&quot;\u6625\u5206\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-04-29&quot; display=&quot;\u662d\u548c\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-05-03&quot; display=&quot;\u61b2\u6cd5\u8a18\u5ff5\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-05-04&quot; display=&quot;\u307f\u3069\u308a\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-05-05&quot; display=&quot;\u3053\u3069\u3082\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-07-18&quot; display=&quot;\u6d77\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-08-11&quot; display=&quot;\u5c71\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-09-19&quot; display=&quot;\u656c\u8001\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-09-23&quot; display=&quot;\u79cb\u5206\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-10-10&quot; display=&quot;\u30b9\u30dd\u30fc\u30c4\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-11-03&quot; display=&quot;\u6587\u5316\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2022-11-23&quot; display=&quot;\u52e4\u52b4\u611f\u8b1d\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-01-01&quot; display=&quot;\u5143\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-01-02&quot; display=&quot;\u4f11\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-01-09&quot; display=&quot;\u6210\u4eba\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-02-11&quot; display=&quot;\u5efa\u56fd\u8a18\u5ff5\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-02-23&quot; display=&quot;\u5929\u7687\u8a95\u751f\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-03-21&quot; display=&quot;\u6625\u5206\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-04-29&quot; display=&quot;\u662d\u548c\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-05-03&quot; display=&quot;\u61b2\u6cd5\u8a18\u5ff5\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-05-04&quot; display=&quot;\u307f\u3069\u308a\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-05-05&quot; display=&quot;\u3053\u3069\u3082\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-07-17&quot; display=&quot;\u6d77\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-08-11&quot; display=&quot;\u5c71\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-09-18&quot; display=&quot;\u656c\u8001\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-09-23&quot; display=&quot;\u79cb\u5206\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-10-09&quot; display=&quot;\u30b9\u30dd\u30fc\u30c4\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-11-03&quot; display=&quot;\u6587\u5316\u306e\u65e5&quot; \/&gt;\n&lt;item value=&quot;2023-11-23&quot; display=&quot;\u52e4\u52b4\u611f\u8b1d\u306e\u65e5&quot; \/&gt;\n&lt;\/items&gt;<\/code><\/pre><\/div>\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=\"OZErUoucmS\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/date-calc-after-n-business-days-2021\/\">#Date: Calc after N Business Days<\/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: Calc after N Business Days&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/date-calc-after-n-business-days-2021\/embed\/#?secret=A379gh552t#?secret=OZErUoucmS\" data-secret=\"OZErUoucmS\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Calculates Business Day Count between datetime A and B to output as numerical value (days). <\/p>\n","protected":false},"author":8,"featured_media":137671,"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":"","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_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_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":[382],"faq_section":[],"class_list":["post-137668","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-date"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["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",1200,630,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?fit=600%2C315&ssl=1",600,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?fit=768%2C403&ssl=1",768,403,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?fit=1024%2C538&ssl=1",1024,538,true],"1536x1536":["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",1200,630,true],"2048x2048":["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",1200,630,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?resize=1200%2C630&ssl=1",1200,630,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?resize=900%2C630&ssl=1",900,630,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?resize=1200%2C630&ssl=1",1200,630,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-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\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?resize=600%2C630&ssl=1",600,630,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?resize=800%2C630&ssl=1",800,630,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-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\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-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\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-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\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-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\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-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\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-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\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-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\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-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\/2022\/10\/eyecatch-two-dates-calculate-duration-exclude-close-days-202209-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["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",1200,630,true]},"uagb_author_info":{"display_name":"furuzo","author_link":"https:\/\/support.questetra.com\/en\/author\/furuzo\/"},"uagb_comment_info":1,"uagb_excerpt":"Calculates Business Day Count between datetime A and B to output as numerical value (days).","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-zOs","jetpack-related-posts":[{"id":87623,"url":"https:\/\/support.questetra.com\/en\/addons\/two-datetimes-calculate-duration\/","url_meta":{"origin":137668,"position":0},"title":"Two Datetimes, Calculate Duration","author":"IMAMURA, Genichi","date":"2020-04-23","format":false,"excerpt":"Calculates the duration between datetime A and B to output as numerical value (days), numerical value (hours), numerical value (minutes), or string value (h:mm). If B is the past time, a minus sign will be added. Date type also available.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Two Datetimes, Calculate Duration","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-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\/04\/Two-Datetimes-Calculate-Duration-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":140981,"url":"https:\/\/support.questetra.com\/en\/addons\/two-dates-calculate-duration-exclude-close-days-202301\/","url_meta":{"origin":137668,"position":1},"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;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/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":76339,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-data-assignment\/","url_meta":{"origin":137668,"position":2},"title":"Update Data","author":"Hirotaka NISHI","date":"2021-09-28","format":false,"excerpt":"Automatically updates Business Data with the specified value or the evaluation result of the formula. Capable of updating several Data Items also in one automatic Step.","rel":"","context":"In &quot;BPMN\u30a2\u30a4\u30b3\u30f3&quot;","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.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\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":87631,"url":"https:\/\/support.questetra.com\/ja\/addons\/two-datetimes-calculate-duration\/","url_meta":{"origin":137668,"position":3},"title":"2\u3064\u306e\u65e5\u6642, \u7d4c\u904e\u6642\u9593\u306e\u8a08\u7b97","author":"IMAMURA, Genichi","date":"2020-04-23","format":false,"excerpt":"\u65e5\u6642A\u304b\u3089\u65e5\u6642B\u307e\u3067\u306e\u7d4c\u904e\u6642\u9593\u3092\u7b97\u51fa\u3057\u307e\u3059\u3002\u6570\u5024\uff08days\uff09\u30fb\u6570\u5024\uff08hours\uff09\u30fb\u6570\u5024\uff08minutes\uff09\u30fb\u6587\u5b57\u5217\uff08h:mm\uff09\u306e\u3044\u305a\u308c\u304b\u3082\u3057\u304f\u306f\u8907\u6570\u3092\u51fa\u529b\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002B\u304c\u904e\u53bb\u6642\u523b\u3067\u3042\u3063\u305f\u5834\u5408\u306f\u30de\u30a4\u30ca\u30b9\u7b26\u53f7\u304c\u4ed8\u4e0e\u3055\u308c\u307e\u3059\u3002AB\u306b\u306f\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\u3092\u6307\u5b9a\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":"2\u3064\u306e\u65e5\u6642, \u7d4c\u904e\u6642\u9593\u306e\u8a08\u7b97","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-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\/2020\/04\/Two-Datetimes-Calculate-Duration-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69428,"url":"https:\/\/support.questetra.com\/en\/addons\/days-calculator\/","url_meta":{"origin":137668,"position":4},"title":"Days Calculator","author":"Hirotaka NISHI","date":"2016-08-29","format":false,"excerpt":"Calculate the number of elapsed days from the two specified dates and store it in a data item","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\/2016\/08\/days-calculator-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/08\/days-calculator-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/08\/days-calculator-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/08\/days-calculator-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/08\/days-calculator-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":110341,"url":"https:\/\/support.questetra.com\/en\/addons\/two-datetimes-calculate-duration-2021\/","url_meta":{"origin":137668,"position":5},"title":"Two Datetimes, Calculate Duration","author":"Hirotaka NISHI","date":"2021-07-27","format":false,"excerpt":"Calculates the duration between datetime A and B to output as numerical value (days), numerical value (hours), numerical value (minutes), or string value (h:mm). If B is the past time, a minus sign will be added. Date type also available","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Two Datetimes, Calculate Duration","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-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\/04\/Two-Datetimes-Calculate-Duration-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"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","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/137668","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=137668"}],"version-history":[{"count":12,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/137668\/revisions"}],"predecessor-version":[{"id":141036,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/137668\/revisions\/141036"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/137671"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=137668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=137668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=137668"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=137668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}