{"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-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\">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> 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-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-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_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":[492,382,494],"faq_section":[],"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":[],"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-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":82721,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-datetime\/","url_meta":{"origin":114674,"position":1},"title":"Let\u2019s Set a Deadline","author":"Peter Glover","date":"2021-10-07","format":false,"excerpt":"How to set the date and time when a Task will occur, and the deadline date when it must be completed.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-deadline-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\/eye-catch-update_data-deadline-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-deadline-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-deadline-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-deadline-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":75859,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/timer-start-event\/","url_meta":{"origin":114674,"position":2},"title":"Timer Start Event","author":"Hirotaka NISHI","date":"2019-03-19","format":false,"excerpt":"Starts a new Process at the specified time. Applies the repetition rule such as daily, weekly on Monday, or the first day of a month.","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\/2019\/10\/bpmn-icon-timer-start-event-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-timer-start-event-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-timer-start-event-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-timer-start-event-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-timer-start-event-1200x675.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":75480,"url":"https:\/\/support.questetra.com\/en\/templates\/daily-report-flow-20180409\/","url_meta":{"origin":114674,"position":3},"title":"Daily Report Flow","author":"Hirotaka NISHI","date":"2021-02-02","format":false,"excerpt":"Automatically starts up every morning for reporting daily business. After the Step of [1. Enter report] is handled, the superior confirms the content at the Step of [2. Daily report confirmation]. If there is a comment, it will be sent to the reporter by email, and if the report needs\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/daily-report-flow-en.png?fit=948%2C421&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/daily-report-flow-en.png?fit=948%2C421&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/daily-report-flow-en.png?fit=948%2C421&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/daily-report-flow-en.png?fit=948%2C421&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":77509,"url":"https:\/\/support.questetra.com\/en\/templates\/product-demo-flow-20161031\/","url_meta":{"origin":114674,"position":4},"title":"Product Demo Flow","author":"Hirotaka NISHI","date":"2021-02-18","format":false,"excerpt":"Accepts product demo requests and carry out the demo. Started by the acceptance of an application via the web form or an email and person in charge will be assigned at the [1. Assignment of Representative] Step. When the representative decides the demo date schedule, it is automatically registered in\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-product-demo-flow-20161031-220-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\/2019\/07\/eye-catch-product-demo-flow-20161031-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-product-demo-flow-20161031-220-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-product-demo-flow-20161031-220-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-product-demo-flow-20161031-220-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":76747,"url":"https:\/\/support.questetra.com\/en\/templates\/daily-report-flow-weather-record-script-task-20210318\/","url_meta":{"origin":114674,"position":5},"title":"Daily report flow-weather record (Script Task)","author":"Hirotaka NISHI","date":"2021-03-18","format":false,"excerpt":"Submits a daily report to the supervisor to be checked at [2. Report Check\/Comment] Step. Automatically retrieves weather data of the day via API and records it.","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/eye-catch-daily-report-flow-weather-record-script-task-20210318-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\/01\/eye-catch-daily-report-flow-weather-record-script-task-20210318-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/eye-catch-daily-report-flow-weather-record-script-task-20210318-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/eye-catch-daily-report-flow-weather-record-script-task-20210318-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/eye-catch-daily-report-flow-weather-record-script-task-20210318-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\/2021\/10\/date-determine-whether-business-day-2021-nocode-en.png?fit=1200%2C675&ssl=1","_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"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=114674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}