{"id":114674,"date":"2021-10-05T16:39:49","date_gmt":"2021-10-05T07:39:49","guid":{"rendered":"https:\/\/support.questetra.com\/?p=114674"},"modified":"2023-08-22T15:13:41","modified_gmt":"2023-08-22T06:13:41","slug":"date-determine-whether-business-day-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/date-determine-whether-business-day-2021\/","title":{"rendered":"#Date: Determine Whether Business Day"},"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, Determine Whether Business Day<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Determines whether the date value is Business Day or not. If a holiday, returns the name of the holiday. If Sat or Sun, returns the day name. Otherwise, returns an empty string. You can also set special holidays set by your company.<\/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 to be Determined (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=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> D1: Select STRING DATA that stores Name of Holiday (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>\/\/ 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\n  engine.log( &quot; AutomatedTask ConfigLog:&quot; +\n              &quot; DayOfWeek of &quot; + strTarget + &quot; (Sun=0,Mon=1): &quot; + dateTarget.getDay() );\nconst strPocketOutput = configs.getObject( &quot;SelectConfD1&quot; ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\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 ==\n\nlet strOutput = &quot;&quot;;\n\nfor( 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\nif( 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\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( strPocketOutput, strOutput );\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\/*\n\nNotes:\n- When the process reaches the automated task, judges whether the date corresponds to a national holiday or a regular closing day.\n    - `YYYY-MM-DD` (date type format), `YYYY\/MM\/DD`, etc.\n    - `YYYY-MM-DD hh:mm` (datetime data format) can also be determined.\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- If no reason to close, an empty string is stored.\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\u304c\u795d\u796d\u65e5\u3084\u5b9a\u4f11\u65e5\u306b\u8a72\u5f53\u3059\u308b\u304b\u3001\u5224\u5b9a\u3067\u304d\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\u5224\u5b9a\u3067\u304d\u307e\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- \u3044\u305a\u308c\u306e\u4f11\u65e5\u306b\u3082\u8a72\u5f53\u3057\u306a\u3044\u5834\u5408\u3001\u7a7a\u6587\u5b57\u304c\u683c\u7d0d\u3055\u308c\u307e\u3059\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\/1GXVS9betBOVo61o31e1ILff7fdpbt4Fs\/view?usp=drivesdk\" target=\"_blank\">date-determine-whether-business-day-2021.xml<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1UqOYPiFdxDFOo5n--eDGgLC27yYhzx-m\/view?usp=sharing\" data-type=\"link\" data-id=\"https:\/\/drive.google.com\/file\/d\/1UqOYPiFdxDFOo5n--eDGgLC27yYhzx-m\/view?usp=sharing\">date-determine-whether-business-day-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-03 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/date-determine-whether-business-day-2021\/\">https:\/\/support.questetra.com\/addons\/date-determine-whether-business-day-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, judges whether the date corresponds to a national holiday or a regular closing day.\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 determined.<\/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>If no reason to close, an empty string is stored.<\/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-determine-whether-business-day-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=\"114662\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/date-determine-whether-business-day-2021-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-2021-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"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.\" class=\"wp-image-114662\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-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\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-config-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"697\" height=\"630\" data-attachment-id=\"114666\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/date-determine-whether-business-day-2021-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-config-en.png?fit=1201%2C1086&amp;ssl=1\" data-orig-size=\"1201,1086\" 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-determine-whether-business-day-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-determine-whether-business-day-2021-config-en.png?fit=697%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-config-en-697x630.png?resize=697%2C630&#038;ssl=1\" alt=\"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.\" class=\"wp-image-114666\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-config-en.png?resize=697%2C630&amp;ssl=1 697w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-config-en.png?resize=348%2C315&amp;ssl=1 348w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-config-en.png?resize=768%2C694&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-2021-config-en.png?w=1201&amp;ssl=1 1201w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><\/a><\/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=\"K8qLtUUT8s\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/date-get-day-of-week-string-2021\/\">#Date: Get Day of Week String<\/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 Day of Week String&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/date-get-day-of-week-string-2021\/embed\/#?secret=eZxAhX4DhV#?secret=K8qLtUUT8s\" data-secret=\"K8qLtUUT8s\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>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.<\/p>\n","protected":false},"author":2,"featured_media":114670,"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":"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.","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":[492,382,494],"class_list":["post-114674","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-attendance-mgmt","tag-date","tag-routine-report"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"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","uagb_featured_image_src":{"full":["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",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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":"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.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-tPA","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":114717,"url":"https:\/\/support.questetra.com\/en\/addons\/date-calc-after-n-business-days-2021\/","url_meta":{"origin":114674,"position":0},"title":"#Date: Calc after N Business Days","author":"IMAMURA, Genichi","date":"2021-10-05","format":false,"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.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Date, Calc after N Business Days","src":"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&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-en.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-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-calc-after-n-business-days-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-calc-after-n-business-days-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":114634,"url":"https:\/\/support.questetra.com\/en\/addons\/date-get-day-of-week-string-2021\/","url_meta":{"origin":114674,"position":1},"title":"#Date: Get Day of Week String","author":"IMAMURA, Genichi","date":"2021-10-05","format":false,"excerpt":"Gets the string for the day of the week. The notation of the day is set in the config such as \"Sun,Mon,Tue,Wed,Thu,Fri,Sat\" or \"Closed,Open,Open,Open,Open,Open,Closed\". The beginning is Sunday.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Date, Get Day of Week String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-get-day-of-week-string-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-get-day-of-week-string-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-get-day-of-week-string-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-get-day-of-week-string-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-get-day-of-week-string-2021-nocode-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":114674,"position":2},"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":114691,"url":"https:\/\/support.questetra.com\/ja\/addons\/date-determine-whether-business-day-2021\/","url_meta":{"origin":114674,"position":3},"title":"#\u65e5\u4ed8: \u55b6\u696d\u65e5\u306e\u5224\u5b9a","author":"IMAMURA, Genichi","date":"2021-10-05","format":false,"excerpt":"\u4efb\u610f\u306e\u65e5\u4ed8\u5024\u304c\u55b6\u696d\u65e5\u3067\u3042\u308b\u304b\u3069\u3046\u304b\u3092\u5224\u5225\u3057\u307e\u3059\u3002\u305d\u306e\u65e5\u4ed8\u3051\u304c\u795d\u796d\u65e5\u306e\u5834\u5408\u3001\u795d\u796d\u65e5\u306e\u540d\u524d\u3092\u8fd4\u3057\u307e\u3059\u3002\u571f\u66dc\u3084\u65e5\u66dc\u306e\u5834\u5408\u3001\u66dc\u65e5\u306e\u540d\u524d\u3092\u8fd4\u3057\u307e\u3059\u3002\u305d\u308c\u4ee5\u5916\u306e\u5834\u5408\u306f\u3001\u7a7a\u306e\u6587\u5b57\u5217\u3092\u8fd4\u3057\u307e\u3059\u3002\u4f1a\u793e\u30aa\u30ea\u30b8\u30ca\u30eb\u306e\u4f11\u65e5\u3092\u8a2d\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":"\u65e5\u4ed8, \u55b6\u696d\u65e5\u306e\u5224\u5b9a","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/date-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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-determine-whether-business-day-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":114674,"position":4},"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":114737,"url":"https:\/\/support.questetra.com\/ja\/addons\/date-calc-after-n-business-days-2021\/","url_meta":{"origin":114674,"position":5},"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":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/114674","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=114674"}],"version-history":[{"count":5,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/114674\/revisions"}],"predecessor-version":[{"id":149939,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/114674\/revisions\/149939"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/114670"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=114674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=114674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=114674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}