{"id":102820,"date":"2021-03-03T17:00:27","date_gmt":"2021-03-03T08:00:27","guid":{"rendered":"https:\/\/support.questetra.com\/?p=102820"},"modified":"2022-06-09T09:51:03","modified_gmt":"2022-06-09T00:51:03","slug":"converter-workflow-datetime-to-iso-datetime-string","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/converter-workflow-datetime-to-iso-datetime-string\/","title":{"rendered":"Converter: Workflow Datetime to ISO-Datetime-String"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" 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=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\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\">Converter: Workflow Datetime to ISO-Datetime-String<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Converts Datetime type data (&#8220;2021-12-31 20:34&#8221; JST) into ISO 8601 datetime string data (&#8220;2021-12-31T20:34:00+09:00&#8221; or &#8220;2021-12-31T11:34:00Z&#8221;). As a general rule Datetime type data is regarded as the time of the Workflow Platform time zone.<\/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-pen-square fa-lg\"><\/i><\/span> A1: Set Workflow Datetime data (eg &#8220;2021-12-31 20:34&#8221;)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A2: To use a time zone other than that of the Workflow Platform, set the offset hours (eg&#8221;-8&#8243;)<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> B1: Select the STRING type Data that stores the ISO Datetime with offset (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B2: To specify the offset, set the offset hours (eg&#8221;+1&#8243;)<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> C1: Select the STRING type Data that stores the ISO Datetime in UTC (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> D: Select the NUMERIC type Data that stores the timestamp (in seconds) (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strWorkflowDatetime = configs.get( &quot;StrConfA1&quot; ); \/\/ required\n  if( strWorkflowDatetime === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A1: Workflow Datetime data} is empty \\n&quot; );\n  }\nconst strWorkflowTz       = configs.get( &quot;StrConfA2&quot; ); \/\/ hour\n  let numWorkflowTz       = engine.getTimeZoneOffsetInMinutes() \/60;\n  if( strWorkflowTz     !== &quot;&quot; ){\n      numWorkflowTz       = parseFloat( strWorkflowTz );\n  }\nconst strPocketIsoOffset  = configs.getObject( &quot;SelectConfB1&quot; );\nconst strIsoOffsetTz      = configs.get( &quot;StrConfB2&quot; ); \/\/ hour\n  let numIsoOffsetTz      = engine.getTimeZoneOffsetInMinutes() \/60;\n  if( strIsoOffsetTz    !== &quot;&quot; ){\n      numIsoOffsetTz      = parseFloat( strIsoOffsetTz );\n  }\n  let strOffset           = &quot;&quot;;\n  let numAbsIsoOffsetTz   = numIsoOffsetTz;\n  if( numIsoOffsetTz &lt; 0){\n      strOffset          += &quot;-&quot;;\n      numAbsIsoOffsetTz   = 0 - numIsoOffsetTz;\n  }else{\n      strOffset          += &quot;+&quot;;\n  }\n  if( numAbsIsoOffsetTz &lt; 10){\n      strOffset          += &quot;0&quot;;\n  }\n  strOffset              += Math.floor( numAbsIsoOffsetTz ) + &quot;:&quot;;\n  if( numAbsIsoOffsetTz * 60 % 60 &lt; 10 ){\n      strOffset          += &quot;0&quot;;\n  }\n  strOffset              += ( numAbsIsoOffsetTz * 60 % 60 ) + &quot;&quot;; \/\/ eg &quot;+09:00&quot;\nengine.log( &quot; AutomatedTask: Workflow Platform offset: &quot; +\n            (engine.getTimeZoneOffsetInMinutes() \/60) );\nengine.log( &quot; AutomatedTask: Workflow Datetime as: &quot; + numWorkflowTz );\nconst strPocketIsoUtc     = configs.getObject( &quot;SelectConfC1&quot; );\nconst numPocketTimestamp  = configs.getObject( &quot;SelectConfD&quot; );\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 ==\nlet dateUniversalTmp = toJsDate( strWorkflowDatetime );\nlet dateUniversal    = new Date( dateUniversalTmp.getTime() +\n                                 engine.getTimeZoneOffsetInMinutes() *60 *1000 -\n                                 numWorkflowTz *60 *60 *1000 );\nlet numMsecUniversal = dateUniversal.getTime();\nengine.log( &quot; AutomatedTask: Timestamp: &quot; + numMsecUniversal );\n\n\/\/ Set time forward\/back with timezone\nlet dateLocaltime    = new Date( dateUniversal.getTime() + numIsoOffsetTz *60 *60 *1000 );\nengine.log( &quot; AutomatedTask: Timestamp Pseudo: &quot; + dateLocaltime.getTime() );\n\n\/\/ The getUTCDate() etc returns number according to universal time.\nlet strIsoOffset  = dateLocaltime.getFullYear() + &quot;-&quot;;\nif( dateLocaltime.getUTCMonth() + 1 &lt; 10 ){\n    strIsoOffset += &quot;0&quot; + (dateLocaltime.getUTCMonth() + 1) + &quot;-&quot;;\n}else{\n    strIsoOffset +=       (dateLocaltime.getUTCMonth() + 1) + &quot;-&quot;;\n}\nif( dateLocaltime.getUTCDate() &lt; 10 ){\n    strIsoOffset += &quot;0&quot; + dateLocaltime.getUTCDate() + &quot;T&quot;;\n}else{\n    strIsoOffset +=       dateLocaltime.getUTCDate() + &quot;T&quot;;\n}\nif( dateLocaltime.getUTCHours() &lt; 10 ){\n    strIsoOffset  += &quot;0&quot; + dateLocaltime.getUTCHours() + &quot;:&quot;;\n}else{\n    strIsoOffset  +=       dateLocaltime.getUTCHours() + &quot;:&quot;;\n}\nif( dateLocaltime.getUTCMinutes() &lt; 10 ){\n    strIsoOffset  += &quot;0&quot; + dateLocaltime.getUTCMinutes() + &quot;:&quot;;\n}else{\n    strIsoOffset  +=       dateLocaltime.getUTCMinutes() + &quot;:&quot;;\n}\nif( dateLocaltime.getUTCSeconds() &lt; 10 ){\n    strIsoOffset  += &quot;0&quot; + dateLocaltime.getUTCSeconds() + &quot;&quot;;\n}else{\n    strIsoOffset  +=       dateLocaltime.getUTCSeconds() + &quot;&quot;;\n}\nstrIsoOffset      += strOffset;\n\nlet strIsoUtc     = dateUniversal.getFullYear() + &quot;-&quot;;\nif( dateUniversal.getUTCMonth() + 1 &lt; 10 ){\n    strIsoUtc    += &quot;0&quot; + (dateUniversal.getUTCMonth() + 1) + &quot;-&quot;;\n}else{\n    strIsoUtc    +=       (dateUniversal.getUTCMonth() + 1) + &quot;-&quot;;\n}\nif( dateUniversal.getUTCDate() &lt; 10 ){\n    strIsoUtc    += &quot;0&quot; + dateUniversal.getUTCDate() + &quot;T&quot;;\n}else{\n    strIsoUtc    +=       dateUniversal.getUTCDate() + &quot;T&quot;;\n}\nif( dateUniversal.getUTCHours() &lt; 10 ){\n    strIsoUtc     += &quot;0&quot; + dateUniversal.getUTCHours() + &quot;:&quot;;\n}else{\n    strIsoUtc     +=       dateUniversal.getUTCHours() + &quot;:&quot;;\n}\nif( dateUniversal.getUTCMinutes() &lt; 10 ){\n    strIsoUtc     += &quot;0&quot; + dateUniversal.getUTCMinutes() + &quot;:&quot;;\n}else{\n    strIsoUtc     +=       dateUniversal.getUTCMinutes() + &quot;:&quot;;\n}\nif( dateUniversal.getUTCSeconds() &lt; 10 ){ \/\/ always &quot;0&quot;\n    strIsoUtc     += &quot;0&quot; + dateUniversal.getUTCSeconds() + &quot;&quot;;\n}else{\n    strIsoUtc     +=       dateUniversal.getUTCSeconds() + &quot;&quot;;\n}\nstrIsoUtc         += &quot;Z&quot;;\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strPocketIsoOffset !== null ){\n  engine.setData(strPocketIsoOffset,   strIsoOffset );\n}\nif( strPocketIsoUtc    !== null ){\n  engine.setData(strPocketIsoUtc,      strIsoUtc );\n}\nif( numPocketTimestamp !== null ){\n  engine.setData( numPocketTimestamp,  new java.math.BigDecimal( numMsecUniversal \/1000 ) );\n} \/\/ Millisec will exceed the numerical limit of workflow platform\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\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;\n  let year       = 0;\n  let monthIndex = 0;\n  let day        = 0;\n  let hours      = 0;\n  let 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)\n  let arrDatetime = bpmsDateOrDatetimeStr.split(&quot; &quot;);\n  if( arrDatetime.length === 1 ){\n    let arrDateParts = arrDatetime[0].split(&quot;-&quot;);\n    year       = parseInt(arrDateParts[0], 10);\n    monthIndex = parseInt(arrDateParts[1], 10) - 1;\n    day        = parseInt(arrDateParts[2], 10);\n  }\n  if( arrDatetime.length === 2 ){\n    let arrDateParts = arrDatetime[0].split(&quot;-&quot;);\n    let arrTimeParts = arrDatetime[1].split(&quot;:&quot;);\n    year       = parseInt(arrDateParts[0], 10);\n    monthIndex = parseInt(arrDateParts[1], 10) - 1;\n    day        = parseInt(arrDateParts[2], 10);\n    hours      = parseInt(arrTimeParts[0], 10);\n    minutes    = parseInt(arrTimeParts[1], 10);\n  }\n  return new Date( year, monthIndex, day, hours, minutes );\n}\n\n\n\n\/*\nNotes:\n- ISO Datetime strings for API Webhook etc can be automatically generated.\n- You will be able to manage the time with timezone info as business data.\n- ISO Datetime with Offset (YYYY-MM-DDThh:mm:ss+09:00)\n    - eg &quot;2021-12-31T20:34:00+00:00&quot;\n    - eg &quot;2022-01-01T05:34:00+09:00&quot;\n    - eg &quot;2021-12-31T12:34:00-08:00&quot;\n- ISO Datetime in UTC (YYYY-MM-DDThh:mm:ssZ)\n    - eg &quot;2021-12-31T20:34:00Z&quot;\n\nNotes-ja:\n- ISO Datetime \u6587\u5b57\u5217\uff08API \u901a\u4fe1\u3084 Webhook \u53d7\u4fe1\u7b49\u3067\u5229\u7528\uff09\u304c\u81ea\u52d5\u751f\u6210\u3055\u308c\u307e\u3059\u3002\n- \u696d\u52d9\u30c7\u30fc\u30bf\u3068\u3057\u3066\u300c\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u60c5\u5831\u3092\u3082\u3063\u305f\u6642\u523b\u300d\u3092\u30c6\u30ad\u30b9\u30c8\u7ba1\u7406\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\n- ISO\u65e5\u6642\u6587\u5b57\u5217\uff08\u30aa\u30d5\u30bb\u30c3\u30c8\u8868\u8a18\uff09\n    - eg &quot;2021-12-31T20:34:00+00:00&quot;\n    - eg &quot;2022-01-01T05:34:00+09:00&quot;\n    - eg &quot;2021-12-31T12:34:00-08:00&quot;\n- ISO\u65e5\u6642\u6587\u5b57\u5217\uff08UTC\u6642\u523b\u8868\u8a18\uff09\n    - eg &quot;2021-12-31T20:34:00Z&quot;\n*\/\n\n\n\/*\nAPPENDIX\n- &quot;Date type + static hh:mm&quot; is also acceptable. (processes the string &quot;YYYY-MM-DD hh:mm&quot;)\n- Wikipedia &quot;ISO 8601&quot;\n    - https:\/\/en.wikipedia.org\/wiki\/ISO_8601\n- The timestamp obtained by this Addon is Unix epoch.\n    - Seconds since 1 January 1970 UTC\n    - Not the same as the ECMAScript epoch (elapsed Milliseconds), Unix is 1\/1000 of ECMAScript\n\nAPPENDIX-ja\n- &quot;\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\uff0b\u56fa\u5b9a\u6642\u523b\u6587\u5b57\u5217&quot; \u306b\u3088\u308b\u6307\u5b9a\u3082\u53ef\u80fd\u3067\u3059\u3002\uff08&quot;YYYY-MM-DD hh:mm&quot; \u306e\u6587\u5b57\u5217\u3092\u51e6\u7406\u3057\u307e\u3059\uff09\n- \u30a6\u30a3\u30ad\u30da\u30c7\u30a3\u30a2 &quot;ISO 8601&quot;\n    - https:\/\/ja.wikipedia.org\/wiki\/ISO_8601\n- \u3053\u306eAddon\u306b\u3088\u3063\u3066\u53d6\u5f97\u3055\u308c\u308b\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306f Unix epoch \uff08&quot;\u7d4c\u904e\u79d2\u6570&quot;\uff09\u3067\u3059\u3002\n    - \u5354\u5b9a\u4e16\u754c\u6642 (UTC) \u306e1970\u5e741\u67081\u65e5\u304b\u3089\u306e\u7d4c\u904e\u79d2\u6570\n    - Unix epoch\uff08&quot;\u7d4c\u904e\u79d2\u6570&quot;\uff09\u306f ECMAScript epoch\uff08&quot;\u7d4c\u904e\u30df\u30ea\u79d2\u6570&quot;\uff09\u306e1000\u5206\u306e1\u3068\u306a\u308a\u307e\u3059\n*\/\n\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAACmElEQVRYR8WXT0gUcRTHP8PSItka\nFkTkZRcSwpuCEARW0jlkoUNRh1pxxy4WBJ324kEMkzpI7qLbLpQFCnvx4M0FkRAMNwJha6M\/ZBlF\nbR1WM4KJn9Ows7Mzs+O4MnOd977v83u\/997v95Pw+JMcx0+wH4UwEmdRaEciCDT\/9y+i8B6JHApZ\nJDJE2XCiXRsgxVH+cBuQgQYnosBvII6fO1zli52PPUAcGYm7QKPDwEazEgq3kIlb+VsDJHgA9LsM\nbHQbJ8p1My1zgDhPkLhYp+CqjMJTZC4ZNasB6rvympmoBFD3fLyuKzeKKfTra6IMoFb7m10UnFPu\nEn6Oa91RBkhwD7jhVMXObqJrgsy7DHMf56zM7hPlpvipAoghA9930Oe2nKsXVmnyN9G30GcFIebE\nYTGsVIA4l5F4pFftPtZNS2OLq4TEOmK0HmxlrbRmDaFwBZnHWgaSwDV9NLGKtuY2VwB6JxuIh0SJ\naBlYQaJ9LwA2\/24y\/GKYwZXBysUo5JDp0DLwQ3ewbBtOdk3SeaTTVQaCB4LbNSCCj74cJfY8ZqZT\nJMohDUBxFcnCSWxfKBCyC656RpFqAgT2BUieTrK+sc7AswFHnIvnF8l+zlqtvKyhA6jaAmElgqfO\npOgJ9pB+laZ3odcRgEMj3RbEqSpCfXCf5GPp6xKFXwWH2pVm85\/mSb9O2xZhVRtOn5smHAojgu\/2\nS+aTZtmraMOqQTR2aozIiQgNPqeXIGtMUwDDIDIdxXqImbczzH6YdZWM\/M88y9+W9b6GUSx+WRxG\nGsRUYaqeRWg4jASAzXE8cnKE4laRodyQqwwYnCyOY2Hl6YVEw\/T0SqZBeHop3ZtM7PBaXs6Ehw8T\nDcLTp5m+fzx7nNaj8200\/gGQ3PghXmX6mAAAAABJRU5ErkJggg==\n\" alt=\"\"\/><\/a><\/figure><\/div>\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\"><li><a href=\"https:\/\/drive.google.com\/file\/d\/1aosfj7jqEeUlD4dkTxHz1LZuhvtFlNqp\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">Converter-Workflow-Datetime-to-ISO-Datetime-String.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-03-01 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-workflow-datetime-to-iso-datetime-string\/\">https:\/\/support.questetra.com\/addons\/converter-workflow-datetime-to-iso-datetime-string\/<\/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.<\/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\"><li>ISO Datetime strings for API Webhooks, etc. can be automatically generated<\/li><li>You will be able to manage the time with time zone info as text in your business data<\/li><li>ISO Datetime with offset (YYYY-MM-DDThh:mm:ss+09:00)<ul><li>e.g. 2021-12-31T20:34:00+00:00<\/li><li>e.g. 2022-01-01T05:34:00+09:00<\/li><li>e.g. 2021-12-31T12:34:00-08:00<\/li><\/ul><\/li><li>ISO Datetime in UTC (YYYY-MM-DDThh:mm:ssZ)<ul><li>e.g. 2021-12-31T20:34:00Z<\/li><\/ul><\/li><\/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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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=\"102824\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/converter-workflow-datetime-to-iso-datetime-string\/attachment\/converter-workflow-datetime-to-iso-datetime-string-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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=\"Converter-Workflow-Datetime-to-ISO-Datetime-String-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Converts Datetime type data (&quot;2021-12-31 20:34&quot; JST) to ISO 8601 datetime string data (&quot;2021-12-31T20:34:00+09:00&quot; or &quot;2021-12-31T11:34:00Z&quot;). As a general rule, Datetime type data is regarded as the time of Workflow Platform timezone.\" class=\"wp-image-102824\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/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\"><li>&#8220;Date type + static hh:mm&#8221; is also acceptable (processes the string &#8220;YYYY-MM-DD hh:mm&#8221;).<\/li><li>Wikipedia &#8220;ISO 8601&#8221;<ul><li><a href=\"https:\/\/en.wikipedia.org\/wiki\/ISO_8601\" rel=\"nofollow\">https:\/\/en.wikipedia.org\/wiki\/ISO_8601<\/a><\/li><\/ul><\/li><li>The timestamp obtained by this Addon is Unix epoch.<ul><li>Seconds since 1 January 1970 UTC<\/li><li>Unix epoch (elapsed seconds) is 1\/1000 of the ECMAScript epoch (elapsed Milliseconds)<\/li><\/ul><\/li><\/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=\"iZwUkMj73X\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-iso-datetime-string-to-workflow-datetime\/\">Converter: ISO-Datetime-String to Workflow Datetime<\/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;Converter: ISO-Datetime-String to Workflow Datetime&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/converter-iso-datetime-string-to-workflow-datetime\/embed\/#?secret=IoGQ7FzYSW#?secret=iZwUkMj73X\" data-secret=\"iZwUkMj73X\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Converts Datetime type data (&#8220;2021-12-31 20:34&#8221; JST) into ISO 8601 datetime string data (&#8220;2021-12-31T20:34:00+09:00&#8221; or &#8220;2021-12-31T11:34:00Z&#8221;). As a general rule Datetime type data is regarded as the time of the Workflow Platform time zone.<\/p>\n","protected":false},"author":2,"featured_media":102821,"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":"Converts Datetime type data (\"2021-12-31 20:34\" JST) to ISO 8601 datetime string data (\"2021-12-31T20:34:00+09:00\" or \"2021-12-31T11:34:00Z\"). As a general rule, Datetime type data is regarded as the time of Workflow Platform timezone.","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":[382],"class_list":["post-102820","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-date"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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":"Converts Datetime type data (\"2021-12-31 20:34\" JST) into ISO 8601 datetime string data (\"2021-12-31T20:34:00+09:00\" or \"2021-12-31T11:34:00Z\"). As a general rule Datetime type data is regarded as the time of the Workflow Platform time zone.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-qKo","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":102829,"url":"https:\/\/support.questetra.com\/ja\/addons\/converter-workflow-datetime-to-iso-datetime-string\/","url_meta":{"origin":102820,"position":0},"title":"\u30b3\u30f3\u30d0\u30fc\u30bf: \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u65e5\u6642 to ISO\u65e5\u6642\u6587\u5b57\u5217","author":"IMAMURA, Genichi","date":"2021-03-03","format":false,"excerpt":"\u65e5\u6642\u578b\u30c7\u30fc\u30bf\uff08\"2021-12-31 20:34\" JST\uff09\u3092ISO 8601 \u65e5\u6642\u6587\u5b57\u5217\u30c7\u30fc\u30bf\uff08\"2021-12-31T20:34:00+09:00\" or \"2021-12-31T11:34:00Z\"\uff09\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u65e5\u6642\u578b\u30c7\u30fc\u30bf\u306f\u539f\u5247\u3068\u3057\u3066\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u306e\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306b\u57fa\u3065\u3044\u3066\u8a55\u4fa1\u8868\u793a\u3055\u308c\u307e\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":"\u30b3\u30f3\u30d0\u30fc\u30bf: \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u65e5\u6642 to ISO\u65e5\u6642\u6587\u5b57\u5217","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-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\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":140651,"url":"https:\/\/support.questetra.com\/ja\/addons\/two-datetimes-calculate-duration-2022\/","url_meta":{"origin":102820,"position":1},"title":"2\u3064\u306e\u65e5\u6642, \u7d4c\u904e\u6642\u9593\u306e\u8a08\u7b97","author":"IMAMURA, Genichi","date":"2022-12-29","format":false,"excerpt":"\u65e5\u6642A\u304b\u3089\u65e5\u6642B\u307e\u3067\u306e\u7d4c\u904e\u6642\u9593\u3092\u7b97\u51fa\u3057\u307e\u3059\u3002\u7d4c\u904e\u65e5\u6570\uff08\u4f8b \"1.38\u65e5\"\uff09\u3001\u7d4c\u904e\u6642\u9593\u6570\uff08\u4f8b \"33.33\u6642\u9593\"\uff09\u3001\u7d4c\u904e\u5206\u6570\uff08\u4f8b \"2000.00\u5206\"\uff09\u3001\u7d4c\u904e\u6642\u9593\uff08\u4f8b \"33:20\"\uff09\u306e\u3044\u305a\u308c\u304b\u3001\u3082\u3057\u304f\u306f\u8907\u6570\u3092\u51fa\u529b\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002B\u304cA\u3088\u308a\u3082\u904e\u53bb\u6642\u523b\u306e\u5834\u5408\u306f\u30de\u30a4\u30ca\u30b9\u7b26\u53f7\u304c\u4ed8\u4e0e\u3055\u308c\u307e\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\/2022\/12\/two-datetimes-calculate-duration-2022-capture-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\/2022\/12\/two-datetimes-calculate-duration-2022-capture-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/two-datetimes-calculate-duration-2022-capture-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/two-datetimes-calculate-duration-2022-capture-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/two-datetimes-calculate-duration-2022-capture-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":140611,"url":"https:\/\/support.questetra.com\/ja\/addons\/converter-date-or-datetime-string-to-workflow-datetime-2022\/","url_meta":{"origin":102820,"position":2},"title":"\u30b3\u30f3\u30d0\u30fc\u30bf: \u65e5\u4ed8\u65e5\u6642\u6587\u5b57\u5217 to \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u65e5\u6642","author":"IMAMURA, Genichi","date":"2022-12-29","format":false,"excerpt":"\"2022-12-31\" \u3084 \"2022-12-31 00:00\" \u3068\u3044\u3063\u305f\u6587\u5b57\u5217\u304b\u3089\u3001\u65e5\u6642\u578b\u30c7\u30fc\u30bf\uff08\u3082\u3057\u304f\u306f\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\uff09\u306b\u5909\u63db\u3057\u307e\u3059\u3002\"2022\u5e7412\u670831\u65e5\" \u3084 \"19700101\" \u3068\u3044\u3063\u305f\u6587\u5b57\u5217\u3082\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002\u3069\u306e\u3088\u3046\u306a\u6587\u5b57\u5217\u3067\u3082\u30ed\u30fc\u30ab\u30eb\u30bf\u30a4\u30e0\u3068\u3057\u3066\u8a55\u4fa1\u3055\u308c\u307e\u3059\u3002\u306a\u304a\u3001\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u5024\uff081970\u5e741\u67081\u65e5\u304b\u3089\u306e\u79d2\u6570\uff09\u3082\u53d6\u5f97\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":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/converter-date-or-datetime-string-to-workflow-datetime-2022-capture-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\/2022\/12\/converter-date-or-datetime-string-to-workflow-datetime-2022-capture-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/converter-date-or-datetime-string-to-workflow-datetime-2022-capture-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/converter-date-or-datetime-string-to-workflow-datetime-2022-capture-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/converter-date-or-datetime-string-to-workflow-datetime-2022-capture-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96508,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":102820,"position":3},"title":"Singleline TSV String, Extract Cell","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Singleline TSV String, Extract Cell","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-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\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82159,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","url_meta":{"origin":102820,"position":4},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u65e5\u4ed8\u30d5\u30a3\u30eb\u30bf\u3055\u308c\u305f\u8907\u6570\u306e\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u8907\u6570\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"string:0,date:2,select:3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","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":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-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\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.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":102820,"position":5},"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":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/102820","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=102820"}],"version-history":[{"count":8,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/102820\/revisions"}],"predecessor-version":[{"id":114747,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/102820\/revisions\/114747"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/102821"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=102820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=102820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=102820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}