{"id":87503,"date":"2020-04-22T16:56:18","date_gmt":"2020-04-22T07:56:18","guid":{"rendered":"https:\/\/support.questetra.com\/?p=87503"},"modified":"2022-06-01T15:34:30","modified_gmt":"2022-06-01T06:34:30","slug":"fiscal-month-day-string-create","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create\/","title":{"rendered":"Fiscal Month-Day String, Create"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5dab2;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFF4CC;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create-2021\/_\">https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create-2021\/<\/a><\/div>\n<\/div><\/div>\n\n\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<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\">Fiscal Month-Day String, Create<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">\n\n\n\n<p class=\"wp-block-paragraph\">Creates a date ID for fiscal year sorting. The first day of the first month of the fiscal year will be &#8220;101&#8221;. The 25th day of the last month is &#8220;1225&#8221;. If the fiscal year starts in Jan, the string will be the same as the calendar format &#8220;Mdd&#8221;.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">2020-04-21 (C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create\/\">https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create\/<\/a><\/p>\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\n\n\n<ul class=\"fa-ul\">\n<li> A: Select DATE DATA<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> B: Set End Month ID of Fiscal Period (eg March: &#8220;3&#8221; )<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> C: Select STR\/NUM DATA that stores the Fiscal Month-Day (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<\/ul>\n\n\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<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ Nashorn Script (engine type: 1)\n\/\/ \n\/\/ Notes:\n\/\/ \"Fiscal Month-Day\" (date ID) is stored as a string.\n\/\/ \"Fiscal Month-Day\" (date ID) can also be stored as a numerical value.\n\/\/ Sorting by date becomes easier, if included in the quote ID, slip ID, etc.\n\/\/ \n\/\/ Notes (ja):\n\/\/ \"\u4f1a\u8a08\u6708\u65e5\"\uff08\u65e5\u4ed8ID\uff09\u306f\u6587\u5b57\u5217\u3068\u3057\u3066\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u306b\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\n\/\/ \"\u4f1a\u8a08\u6708\u65e5\"\uff08\u65e5\u4ed8ID\uff09\u306f\u6570\u5024\u3068\u3057\u3066\u6570\u5024\u578b\u30c7\u30fc\u30bf\u306b\u683c\u7d0d\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\n\/\/ \u898b\u7a4d\u66f8\u3084\u4f1d\u7968\u306a\u3069\u306e\u7ba1\u7406ID\u306b\u542b\u3081\u308b\u3068\u3001\u65e5\u4ed8\u9806\u30bd\u30fc\u30c8\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002\n\/\/\n\/\/  &#091;M] numMonthSerial (Serial Number, 1 means the first month of the fiscal year.)\n\/\/               01 02 03 04 05 06 07 08 09 10 11 12\n\/\/  EndMonth= 1: 12  1  2  3  4  5  6  7  8  9 10 11\n\/\/  EndMonth= 3: 10 11 12  1  2  3  4  5  6  7  8  9\n\/\/  EndMonth=12:  1  2  3  4  5  6  7  8  9 10 11 12\n\n\n\/\/\/\/\/\/\/\/ START \"main()\" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){\n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA     = configs.get( \"conf_DataIdA\" )  + \"\"; \/\/ required\nconst strEndMonth = configs.get( \"conf_EndMonth\" ) + \"\"; \/\/ required\nconst dataIdC     = configs.get( \"conf_DataIdC\" )  + \"\"; \/\/ required\n\nlet numEndMonth = 0;\nconst regMonthInt = \/^(&#091;1-9]|1&#091;0-2])$\/; \/\/ RegExp: 1,2,,,11,12\nif( regMonthInt.test( strEndMonth ) ){\n  numEndMonth = parseInt(strEndMonth, 10);\n}else{\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {B:EndMonth} must be 1 to 12 \\n\" );\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nif( engine.findDataByNumber( dataIdA ) === null ){\n  throw new Error( \"\\n AutomatedTask UnexpectedDateError:\" +\n                   \" Date {A} is null \\n\" );\n}\nstrDateA = engine.findDataByNumber( dataIdA ) + \"\"; \/\/ e.g. 2020-04-30\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet year       = 0;\nlet monthIndex = 0;\nlet day        = 0;\nlet arrDateParts = strDateA.split(\"-\");\n    year       = parseInt(arrDateParts&#091;0], 10);\n    monthIndex = parseInt(arrDateParts&#091;1], 10) - 1; \/\/ 3\n    day        = parseInt(arrDateParts&#091;2], 10);     \/\/ 30\n\nlet numMdd     = monthIndex * 100 + day; \/\/ e.g. 330\n    numMdd     = (numMdd + 1200 - (numEndMonth * 100) ) % 1200 + 100;\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( engine.findDataDefinitionByNumber( dataIdC ).matchDataType(\"DECIMAL\") ){\n  engine.setDataByNumber( dataIdC, new java.math.BigDecimal(numMdd) );\n}else{\n  engine.setDataByNumber( dataIdC, (numMdd + \"\") );\n}\n\n\n} \/\/\/\/\/\/\/\/ END \"main()\" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/code><\/pre>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" src=\"data:image;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADkklEQVRYR8WXW0gUYRSAv1lz1Uzs\nQnYxIymjLKKLZoWk0VM9RBRERT5UxK4SlFj4WOBLglQE1RqYUFEPkUEQ3SlSzCBKESwquq7pBu5q\n5drathP\/bJOzs7M622b7Pw7nnP875z+3kYjzkUzfX8tYZDYhsQaZJUjMAib81vcg8w6JZ8jcR6IB\nG14ztkcGqGcqg1QCdiDZjFHgO+DASjU76R5OZ3gAB3YkaoBUkxfrxfqROYAdRyT9yAC1nAJK\/\/Ji\nvdppbJQZ2TIGcHARiW3\/6PKgGZlL2NmutxkOYOB5\/uR86orquOO8Q0VLhWJjbvpczq05R7u7nT0P\n9\/yx27ShiU\/eT2y5u8WIPywSoQDBNz+t1ZyROoPCqYXUrKjhXuc9bjlvkSAlkJyQzKFlh3jZ95Iz\nz8+QaEnE6\/dSlV9Fl7eLw08O09jdGA4hU6rNiSGAYLa\/1iZcVV4VFYsqaHO3kZWaxftv78mbnIfV\nYuXNlzckJSThGnCRk55DWmIanf2d+H766B7oJjstm8HAIKWNpdz4eEML0o+VOWp1DAHUcgzYr0qu\ny1pHfXE9U1KmKB4JzzPHZrI2cy0WycLngc886HpAkiWJ9TPXKxHoG+zj5sebSJLExlkbFVARhdXX\nVusjcRwb5eJjEEA0GejR1nlJTgknC08qnsVyOjwdLLi8QG9C9IlJolkFARzsQOK8VmqUAURVlGDn\nghqBOmCXUfKJ0MZy3D431z9cNzJxFhu71Qg8RWKJVmrr7K0cXXmUcYnjYrmfF70vWH51uVE1PMPO\nUjUCbs1gUYRH\/QnAg42JKoCsR\/wPAGBDihrA2e+k8nGl0geOFByhaFoRbT1tHHx8kBOrTjBv\/LwQ\nXyJUQVBGA2D6CTw+D37ZT6+vl4a3DZQvKueR6xFX3l7BPt9O7oRcswCaJ3AQloTDPcGrvlfsa96n\ntOKCjAKl41W3VrM5e7N5AJmQJAwrw+EA\/AG\/MgNE19u7cK\/icdQAEFKGphtRs6uZ1p5WpdeLSJTl\nlhEgED2ArhGZbsUi3C2uFkQuFE8vJt2aTkAOKHkghlJGSoaZHNC14uA8CBlGo1yGumEkAHTjWDsN\nY2mFBtMwwjgODqWQhUTdB1LGpPwVg9gfwvaBiAuJeoVuJRN1vXjSYmULiuaI7ei28zZff3zVqo2w\nkqmicV1KI0QiGu8NZKNcy4ciEccfExUirr9m2ljG7ec0xscfSf0XS7acMEfzklQAAAAASUVORK5C\nYII=\" alt=\"\"\/><\/figure><\/div>\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-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/a\/questetra.com\/file\/d\/14kggF88EgddRWBJ-_Y_UACdYsjAlwzE9\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Fiscal-Month-Day-String-Create.xml<\/a><\/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-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" data-comments-opened=\"0\" data-image-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=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/fiscal-month-day-create.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener noreferrer\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"87506\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create\/attachment\/fiscal-month-day-string-create-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-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=\"Fiscal-Month-Day-String-Create-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Creates a date ID for fiscal year sorting. The first day of the first month of the fiscal year will be &quot;101&quot;. The 25th day of the last month is &quot;1225&quot;. If the fiscal year starts in Jan, the string will be the same as the calendar format &quot;Mdd&quot;.\" class=\"wp-image-87506\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-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-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>&#8220;Fiscal Month-Day&#8221; (date ID) is stored as a string.<\/li><li>&#8220;Fiscal Month-Day&#8221; (date ID) can also be stored as a numerical value.<\/li><li>Sorting by date becomes easier, if included in the quote ID, slip ID, etc.<\/li><\/ol>\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-wordpress wp-block-embed-wordpress is-provider-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"VzzyOgszyq\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/\">MoneyForward Journal, Create<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cMoneyForward Journal, Create\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/embed\/#?secret=Zn58JM07Mg#?secret=VzzyOgszyq\" data-secret=\"VzzyOgszyq\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Creates a date ID for fiscal year sorting. The first day of the first month of the fiscal year will be &#8220;101&#8221;. The 25th day of the last month is &#8220;1225&#8221;. If the fiscal year starts in Jan, the string will be the same as the calendar format &#8220;Mdd&#8221;.<\/p>\n","protected":false},"author":2,"featured_media":87504,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","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":[],"class_list":["post-87503","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-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\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-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":"Creates a date ID for fiscal year sorting. The first day of the first month of the fiscal year will be \"101\". The 25th day of the last month is \"1225\". If the fiscal year starts in Jan, the string will be the same as the calendar format \"Mdd\".","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-mLl","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":87510,"url":"https:\/\/support.questetra.com\/ja\/addons\/fiscal-month-day-string-create\/","url_meta":{"origin":87503,"position":0},"title":"\u4f1a\u8a08\u6708\u65e5\u6587\u5b57\u5217, \u751f\u6210","author":"IMAMURA, Genichi","date":"2020-04-22","format":false,"excerpt":"\u4f1a\u8a08\u5e74\u5ea6\u5185\u30bd\u30fc\u30c8\u7528\u306e\u65e5\u4ed8ID\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u4f1a\u8a08\u5e74\u5ea6\u306e\u958b\u59cb\u6708\u306e\u521d\u65e5\u306f \"101\" \u306b\u3001\u6700\u7d42\u6708\u306e25\u65e5\u306f \"1225\" \u3068\u306a\u308a\u307e\u3059\u3002\u6c7a\u7b97\u6708\u304c12\u6708\uff08\u4f1a\u8a08\u5e74\u5ea6\u306e\u958b\u59cb\u6708\u304c1\u6708\uff09\u306e\u5834\u5408\u306f\u3001\u30ab\u30ec\u30f3\u30c0\u30fc\u65e5\u4ed8\u306e \"Mdd\" \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3068\u540c\u3058\u6587\u5b57\u5217\u306b\u306a\u308a\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":"\u4f1a\u8a08\u6708\u65e5\u6587\u5b57\u5217, \u751f\u6210","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-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\/Fiscal-Month-Day-String-Create-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":110001,"url":"https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create-2021\/","url_meta":{"origin":87503,"position":1},"title":"Fiscal Month-Day String, Create","author":"Hirotaka NISHI","date":"2021-07-20","format":false,"excerpt":"Creates a date ID for fiscal year sorting. The first day of the first month of the fiscal year will be \"101\". The 25th day of the last month is \"1225\". If the fiscal year starts in Jan, the string will be the same as the calendar format \"Mdd\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Fiscal Month-Day String, Create","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-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\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":87048,"url":"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/","url_meta":{"origin":87503,"position":2},"title":"MoneyForward Journal, Create","author":"IMAMURA, Genichi","date":"2020-04-09","format":false,"excerpt":"Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only invoices that are booked as single sales record, but also invoices that are booked as monthly sales records.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"MoneyForward Journal, Create","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-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\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79738,"url":"https:\/\/support.questetra.com\/en\/data-items\/datetime-type\/","url_meta":{"origin":87503,"position":3},"title":"Datetime-Type","author":"Peter Glover","date":"2024-09-02","format":false,"excerpt":"Displays a field for entering the date and a field for hours and minutes, and stores the date and time entered.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Datetime.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\/09\/Datetime.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Datetime.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Datetime.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Datetime.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79735,"url":"https:\/\/support.questetra.com\/en\/data-items\/date-type\/","url_meta":{"origin":87503,"position":4},"title":"Date-Type","author":"Peter Glover","date":"2024-09-02","format":false,"excerpt":"Displays a text field that accepts numeric values in a specified date format.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Date.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\/09\/Date.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Date.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Date.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Date.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":87057,"url":"https:\/\/support.questetra.com\/ja\/addons\/moneyforward-journal-create\/","url_meta":{"origin":87503,"position":5},"title":"\u30de\u30cd\u30fc\u30d5\u30a9\u30ef\u30fc\u30c9\u4ed5\u8a33\u4f1d\u7968, \u751f\u6210","author":"IMAMURA, Genichi","date":"2020-04-09","format":false,"excerpt":"MoneyForward\u30af\u30e9\u30a6\u30c9\u4f1a\u8a08\u7528\u306e\u4ed5\u8a33\u4f1d\u7968\uff08TSV or Excel\uff09\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u4e00\u62ec\u3057\u3066\u58f2\u4e0a\u8a08\u4e0a\u3055\u308c\u308b\u8acb\u6c42\u66f8\u3060\u3051\u3067\u306a\u304f\u5404\u6708\u306b\u6309\u5206\u8a08\u4e0a\u3055\u308c\u308b\u8acb\u6c42\u66f8\u306b\u3082\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002\u306a\u304a\u3001\u58f2\u4e0a\u8a08\u4e0a\u65e5\u304c\u300c\u4e88\u5b9a\u5165\u91d1\u65e5\u300d\u3088\u308a\u672a\u6765\u306b\u306a\u308b\u58f2\u4e0a\u4f1d\u7968\u306e\u52d8\u5b9a\u79d1\u76ee\u306f \"\u58f2\u639b\u91d1\u58f2\u4e0a\" \u3067\u306f\u306a\u304f \"\u524d\u53d7\u91d1\u58f2\u4e0a\" \u3068\u5224\u65ad\u3055\u308c\u307e\u3059\u3002\u307e\u305f\u3001\u8acb\u6c42\u91d1\u984d\u3092\u6309\u5206\u3057\u305f\u969b\u306e\u5270\u4f59\uff08\u7aef\u6570\uff09\u306f\u521d\u6708\u58f2\u4e0a\u30ec\u30b3\u30fc\u30c9\u306b\u52a0\u7b97\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"\u30de\u30cd\u30fc\u30d5\u30a9\u30ef\u30fc\u30c9\u4ed5\u8a33\u4f1d\u7968, \u751f\u6210","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-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\/MoneyForward-Journal-Create-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/87503","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=87503"}],"version-history":[{"count":4,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/87503\/revisions"}],"predecessor-version":[{"id":110144,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/87503\/revisions\/110144"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/87504"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=87503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=87503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=87503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}