{"id":140397,"date":"2022-12-29T14:44:58","date_gmt":"2022-12-29T05:44:58","guid":{"rendered":"https:\/\/support.questetra.com\/?p=140397"},"modified":"2022-12-29T14:44:59","modified_gmt":"2022-12-29T05:44:59","slug":"converter-date-or-datetime-string-to-workflow-datetime-2022","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/converter-date-or-datetime-string-to-workflow-datetime-2022\/","title":{"rendered":"Converter: Date-or-Datetime-String to Workflow Datetime"},"content":{"rendered":"\n

Converter: Date-or-Datetime-String to Workflow Datetime<\/strong><\/h4>\n\n\n\n

\u30b3\u30f3\u30d0\u30fc\u30bf: \u65e5\u4ed8\u65e5\u6642\u6587\u5b57\u5217 to \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u65e5\u6642<\/a><\/p>\n\n\n\n

Converts strings such as “2022-12-31” or “2022-12-31 00:00” to Datetime (or Date) data. Also supports strings like “2022\/12\/31” and “19700101”. Any string is evaluated as local time. The timestamp value (seconds since 1 Jan 1970) is also gettable.<\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA<\/dt>
A: Set Datetime String (like “2022-12-31 00:00”) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
SelectConfB1<\/dt>
B1: Select DATETIME\/DATE DATA (update) *<\/span><\/dd>\n
SelectConfB2<\/dt>
B2: Select NUMERIC DATA for Timestamp Sec (update)<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strInput          = configs.get      ( "StrConfA" );     \/\/\/ REQUIRED\n  if( strInput        === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A: String} is empty \\n" );\n  }\nconst dtPocketOutput    = configs.getObject( "SelectConfB1" ); \/\/\/ REQUIRED\nconst numPocketUnixtime = configs.getObject( "SelectConfB2" ); \/\/ NotRequired\n\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\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nconst dateInput     = parseAsLocalDate ( strInput ); \/\/ strDateOrDatetime\nconst numMsecInput  = dateInput.getTime();\n\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( dtPocketOutput.matchDataType( "DATETIME" ) ){\n  engine.setData( dtPocketOutput, new java.sql.Timestamp( numMsecInput ) );\n    \/\/ setData() -- R2301: Script Data Retrieving \/ Updating\n    \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574771-R2301\n    \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574771-R2301\n    \/\/  `java.sql.Timestamp (msec)` to `com.questetra.bpms.util.AddableTimestamp`\n}else{\n  engine.setData( dtPocketOutput, new java.sql.Date( numMsecInput ) );\n    \/\/  `java.sql.Date (msec)`      to `com.questetra.bpms.util.AddableDate`\n}\n\nif( numPocketUnixtime !== null ){\n  engine.setData( numPocketUnixtime, new java.math.BigDecimal( numMsecInput \/1000 ) );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\nfunction parseAsLocalDate ( str ){ \/\/ strDateOrDatetime\n  \/\/\n  \/\/ Searches a Date-or-Datetime String for YYYY, MM, DD, hh:mm in that order and\n  \/\/  returns JavaScript `Date` object.\n  \/\/ Any format is forcibly recognized as LOCAL DATETIME. -- UNIQUE --\n  \/\/ Supports "ISO 8601 format", "BPMS date format", "BPMS datetime format", etc,,,\n  \/\/\n  \/\/ String "2022-12-31 23:59"          (Questetra BPMS datetime format)\n  \/\/ \u21d2 Date 2022-12-31T23:59:00+XX:00\n  \/\/ String "2022-12-31 23:59:59"       (SQL Time format)\n  \/\/ \u21d2 Date 2022-12-31T23:59:00+XX:00\n  \/\/ String "2022-12-31T23:59:59.999Z"  (ISO 8601 format)\n  \/\/ \u21d2 Date 2022-12-31T23:59:00+XX:00   \/\/ UNIQUE: Timezone not evaluated\n  \/\/ String "2022-12-31"                (Questetra BPMS date format) \n  \/\/ \u21d2 Date 2022-12-31T00:00:00+XX:00   \/\/ UNIQUE: not UTC\n  \/\/ String "2022\/12\/31"                (Windows date-ja format)\n  \/\/ \u21d2 Date 2022-12-31T00:00:00+XX:00   \/\/ UNIQUE: not UTC\n  \/\/ String "2022\u5e7412\u670831\u65e5"            (\u65e5\u672c\u8a9e\/Japanese)\n  \/\/ \u21d2 Date 2022-12-31T00:00:00+XX:00\n  \/\/\n  \/\/ String "20221231"\n  \/\/ \u21d2 Date 2022-12-31T00:00:00+XX:00   \/\/ UNIQUE: not UTC\n  \/\/ String "20221231T235959Z"          (ISO 8601 format)\n  \/\/ \u21d2 Date 2022-12-31T23:59:00+XX:00   \/\/ UNIQUE: Timezone not evaluated\n  \/\/ String "20221231T2359"\n  \/\/ \u21d2 Date 2022-12-31T23:59:00+XX:00\n\n  if( str === "" ){\n    throw new Error( "\\n AutomatedTask ParseDateError:" +\n                     " String is empty \\n" );\n  }\n  const arrNumParts = str.match( \/\\d+\/g );\n  if( arrNumParts === null ){\n    throw new Error( "\\n AutomatedTask ParseDateError:" +\n                     " No numeric characters in: " + str + "\\n" );\n  }\n\n  \/\/\/ function default\n  let numYear    = 0; \/\/ limit in QBPMS: 1900 to 2100 (asof 2022-12)\n  let indexMonth = 0;\n  let numDay     = 0;\n  let numHours   = 0;\n  let numMinutes = 0;\n\n  \/\/\/ case: startsWith YYYYMMDD\n  if( arrNumParts[0].length === 8 ){\n    numYear      = parseInt( arrNumParts[0].slice( 0, 4 ), 10 );\n    indexMonth   = parseInt( arrNumParts[0].slice( 4, 6 ), 10 ) - 1;\n    numDay       = parseInt( arrNumParts[0].slice( 6, 8 ), 10 );\n    if( arrNumParts.length > 1 ){ \/\/ "20221231T2359"\n      numHours   = parseInt( arrNumParts[1].slice( 0, 2 ), 10 );\n      numMinutes = parseInt( arrNumParts[1].slice( 2, 4 ), 10 );\n    }\n\n  \/\/\/ case: not startsWith YYYYMMDD, like "2022-12-31 23:59"\n  }else{\n    if( arrNumParts.length < 3){\n      throw new Error( "\\n AutomatedTask ParseDateError:" +\n                       " 3 Parts of numeric characters are needed in: " + str + "\\n" );\n    }\n    numYear      = parseInt( arrNumParts[0], 10 );\n    indexMonth   = parseInt( arrNumParts[1], 10 ) - 1;\n    numDay       = parseInt( arrNumParts[2], 10 );\n    if( arrNumParts.length > 4){\n      numHours   = parseInt( arrNumParts[3], 10 );\n      numMinutes = parseInt( arrNumParts[4], 10 );\n    }\n  }\n\n  \/\/\/ return JavaScript `Date` object\n  return new Date( numYear, indexMonth, numDay, numHours, numMinutes );\n}\n\n\n\/*\nNotes:\n- This function evaluates both "2022-12-31" and "2022-12-31 00:00" as local time. UNIQUE\n    - In JST platform, both are interpreted as "2022-12-30T15:00:00Z" (2022-12-31T00:00:00+09:00).\n    - BTW, many systems consider "2022-12-31" as UTC time. (ES5, ECMAScript 2015, etc.)\n- The 1st numeric part is assumed to be the "year". The 2nd "month" and the 3rd "day". (separator independent)\n    - The 4th numeric part is considered "hour", the 5th "minute". (separator independent)\n    - "2022-12-31 23:59" \u21d2 `2022-12-31T23:59:00+XX:00`\n- However, it will be regarded as "YYYYMMDD" only if the 1st is an 8-digit. (assuming the 2nd is "hhmm...")\n    - "19700101" \u21d2 `1970-01-01T00:00:00+09:00`\n    - "19700101T012345" \u21d2 `1970-01-01T01:23:00+09:00`\n- BTW, "Date.parse()" is danger (strongly discouraged). Not used in this function.\n    - new Date( "2022-12-31") \/\/ 2022-12-31T00:09:00+09:00 \/\/ Basically as UTC.\n    - new Date( 2022, 11, 31) \/\/ 2022-12-31T00:00:00+09:00 \/\/ Parameter values as Localtime\n    - If you want "Date.parse(str)" to interpret the timezone,\n        - "Converter: ISO-Datetime-String to Workflow Datetime"\n        - https:\/\/support.questetra.com\/addons\/converter-iso-datetime-string-to-workflow-datetime\/\nAPPENDIX:\n- Unix time is the number of seconds that have elapsed since the Unix epoch, minus leap seconds.\n    - The Unix epoch is 00:00:00 UTC on 1 January 1970 (an arbitrary date).\n    - Unix time is also known as Epoch time, POSIX time, seconds since the Epoch, or UNIX Epoch time.\n    - ECMAScript epoch time ("milliseconds") is 1000 times the value of Unix time ("seconds").\n- Wikipedia: Unix Time, UTC\n    - https:\/\/en.wikipedia.org\/wiki\/Unix_time\n    - https:\/\/en.wikipedia.org\/wiki\/Coordinated_Universal_Time\n- Note, the "Serial Number" in Spreadsheet or Excel is the number of days since 1899-12-30 00:00.\n    - https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/DateTimeRenderOption\n\nNotes-ja:\n- \u3053\u306e\u95a2\u6570\uff08\u81ea\u52d5\u5de5\u7a0b\uff09\u3067\u306f "2022-12-31" \u3082 "2022-12-31 00:00" \u3082\u30ed\u30fc\u30ab\u30eb\u30bf\u30a4\u30e0\u3068\u3057\u3066\u8a55\u4fa1\u3057\u307e\u3059\u3002UNIQUE\n    - \u3064\u307e\u308aJST\u57fa\u76e4\u3067\u306f\u3001\u3069\u3061\u3089\u3082 "2022-12-30T15:00:00Z" (2022-12-31T00:00:00+09:00) \u3068\u89e3\u91c8\u3055\u308c\u307e\u3059\u3002\n    - \u306a\u304a\u591a\u304f\u306e\u51e6\u7406\u7cfb\u306f "2022-12-31" \u3092 UTC \u6642\u523b\u3068\u898b\u306a\u3057\u307e\u3059\u3002\uff08ES5\u3001ECMAScript 2015 \u7b49\uff09\n- \u7b2c1\u756a\u76ee\u306e\u6570\u5b57\u90e8\u306f\u300c\u5e74\u300d\u3068\u307f\u306a\u3055\u308c\u307e\u3059\u3002\u7b2c2\u756a\u76ee\u306f\u300c\u6708\u300d\u3001\u7b2c3\u756a\u76ee\u306f\u300c\u65e5\u300d\u3068\u307f\u306a\u3055\u308c\u307e\u3059\u3002\uff08\u30bb\u30d1\u30ec\u30fc\u30bf\u975e\u4f9d\u5b58\uff09\n    - \u7b2c4\u756a\u76ee\u306e\u6570\u5b57\u90e8\u306f\u300c\u6642\u300d\u3001\u7b2c5\u756a\u76ee\u306f\u300c\u5206\u300d\u3068\u307f\u306a\u3055\u308c\u307e\u3059\u3002\uff08\u30bb\u30d1\u30ec\u30fc\u30bf\u975e\u4f9d\u5b58\uff09\n    - "2022-12-31 23:59" \u21d2 `2022-12-31T23:59:00+XX:00`\n- \u305f\u3060\u3057\u7b2c1\u756a\u76ee\u306e\u6570\u5b57\u90e8\u304c8\u6841\u6570\u5b57\u306e\u5834\u5408\u306b\u9650\u308a\u300cYYYYMMDD\u300d\u3068\u307f\u306a\u3057\u3001\u7b2c2\u756a\u76ee\u3092\u300chhmm\u2026\u300d\u3068\u307f\u306a\u3057\u307e\u3059\u3002\n    - "19700101" \u21d2 `1970-01-01T00:00:00+09:00`\n    - "19700101T012345" \u21d2 `1970-01-01T01:23:00+09:00`\n- \u306a\u304a\u3001\u66d6\u6627\u4ed5\u69d8\u306e "Date.parse(str)" \u306f\u3001\u3053\u306e\u95a2\u6570\u3067\u306f\u5229\u7528\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002\n    - new Date( "2022-12-31") \/\/ 2022-12-31T00:09:00+09:00 \/\/ DANGER: Basically as UTC. \n    - new Date( 2022, 11, 31) \/\/ 2022-12-31T00:00:00+09:00 \/\/ Parameter values as Localtime\n    - "Date.parse(str)" \u306b\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u3092\u89e3\u91c8\u3055\u305b\u305f\u3044\u5834\u5408\u306f\n        - \u81ea\u52d5\u5de5\u7a0b "\u30b3\u30f3\u30d0\u30fc\u30bf: ISO\u65e5\u6642\u6587\u5b57\u5217 to \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u65e5\u6642"\n        - https:\/\/support.questetra.com\/ja\/addons\/converter-iso-datetime-string-to-workflow-datetime\/\nAPPENDIX-ja:\n- Unix\u6642\u9593\u306f\u300cUnix\u30a8\u30dd\u30c3\u30af\u300d\u304b\u3089\u306e\u7d4c\u904e\u79d2\u6570\u3067\u3059\u3002\uff08\u3046\u308b\u3046\u79d2\u306e\u5b58\u5728\u306f\u6392\u9664\u3055\u308c\u307e\u3059\uff09\n    - Unix\u30a8\u30dd\u30c3\u30af\u306f\u3001\u5354\u5b9a\u4e16\u754c\u6642\uff08UTC\uff09\u306e1970\u5e741\u67081\u65e500:00:00\u3092\u6307\u3057\u307e\u3059\u3002\uff08\u610f\u5473\u306e\u3042\u308b\u65e5\u3067\u306f\u306a\u3044\uff09\n    - Unix\u6642\u9593\u306f\u3001Unix\u30bf\u30a4\u30e0\u3001\u30a8\u30dd\u30c3\u30af\u30bf\u30a4\u30e0\u3001POSIX\u30bf\u30a4\u30e0\u3001Unix\u30a8\u30dd\u30c3\u30af\u30bf\u30a4\u30e0\u306a\u3069\u3068\u3082\u547c\u3070\u308c\u307e\u3059\u3002\n    - ECMAScript epoch time\uff08"\u7d4c\u904e\u30df\u30ea\u79d2\u6570"\uff09\u306f\u3001Unix time\uff08"\u7d4c\u904e\u79d2\u6570"\uff09\u306e1000\u500d\u306e\u5024\u306b\u306a\u308a\u307e\u3059\u3002\n- Wikipedia: Unix Time, UTC\n    - https:\/\/ja.wikipedia.org\/wiki\/UNIX%E6%99%82%E9%96%93\n    - https:\/\/ja.wikipedia.org\/wiki\/%E5%8D%94%E5%AE%9A%E4%B8%96%E7%95%8C%E6%99%82\n- \u306a\u304a\u3001Spreadsheet \u3084 Excel \u306b\u304a\u3051\u308b "Serial Number" \u306f\u30011899-12-30 00:00 \u304b\u3089\u306e\u7d4c\u904e\u65e5\u6570\u3067\u3059\u3002\n    - https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/DateTimeRenderOption\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n