{"id":4039,"date":"2013-09-03T16:35:53","date_gmt":"2013-09-03T07:35:53","guid":{"rendered":"http:\/\/synergylead.jp\/?p=4039"},"modified":"2021-01-26T18:02:12","modified_gmt":"2021-01-26T09:02:12","slug":"salesforce-formula-to-calculate-time-subtraction","status":"publish","type":"post","link":"https:\/\/www.synergy-marketing.co.jp\/blog\/salesforce-formula-to-calculate-time-subtraction","title":{"rendered":"Salesforce\u3067\u3001\u5206\u5358\u4f4d\u3067\u6642\u9593\u5dee\u3092\u7b97\u51fa\u3059\u308b\u6570\u5f0f"},"content":{"rendered":"<p>Salesforce\u306eTips\u3067\u3059\u3002\u300c\u65e5\u4ed8\/\u6642\u9593\u578b\u300d\u9805\u76ee\u306e\u6642\u9593\u5dee\u3092\u7b97\u51fa\u3059\u308b\u6570\u5f0f\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3061\u3087\u3063\u3068\u7121\u7406\u3084\u308a\u611f\u304c\u3042\u308a\u307e\u3059\u304c\u30012\u3064\u306e\u300c\u65e5\u4ed8\/\u6642\u9593\u578b\u300d\u9805\u76ee\u306e\u6642\u9593\u5dee\u3092\u5206\u5358\u4f4d\u3067\u51fa\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4040\" src=\"https:\/\/www.synergy-marketing.co.jp\/blog\/wp\/wp-content\/uploads\/2014\/06\/20130903_TimeLag-resized-600.png\" alt=\"20130903_TimeLag-resized-600\" width=\"291\" height=\"80\" \/><\/p>\n<p><pre class=\"brush: java; title: Salesforce\u3067\u3001\u5206\u5358\u4f4d\u3067\u6642\u9593\u5dee\u3092\u7b97\u51fa\u3059\u308b\u6570\u5f0f; notranslate\" title=\"Salesforce\u3067\u3001\u5206\u5358\u4f4d\u3067\u6642\u9593\u5dee\u3092\u7b97\u51fa\u3059\u308b\u6570\u5f0f\">\r\n((DATE(VALUE(MID( TEXT( EndDateTime__c ), 1, 4 )),VALUE(MID( TEXT( EndDateTime__c ), 6, 2 )),VALUE(MID( TEXT( EndDateTime__c ), 9, 2 )))) -\r\n  DATE(VALUE(MID( TEXT( StartDateTime__c ), 1, 4 )) ,VALUE(MID( TEXT( StartDateTime__c ), 6, 2 )) ,VALUE(MID( TEXT( StartDateTime__c ), 9, 2 )) )) * 24 * 60\r\n  +\r\n  (VALUE(MID( TEXT( EndDateTime__c ), 12, 2)) - VALUE(MID( TEXT( StartDateTime__c ), 12, 2))) * 60\r\n  +\r\n  VALUE(MID( TEXT( EndDateTime__c ), 15, 2)) - VALUE(MID( TEXT( StartDateTime__c ), 15, 2))\r\n<\/pre>\n<\/p>\n<p>\u4ed6\u306b\u3082\u3001\u65e5\u4ed8\u3084\u66dc\u65e5\u95a2\u9023\u306e\u6570\u5f0f\u3092\u7d39\u4ecb\u3057\u3066\u3044\u308b\u30a6\u30a7\u30d6\u30da\u30fc\u30b8\u3092\u307e\u3068\u3081\u307e\u3057\u305f\u3002\u4ee5\u4e0b3\u70b9\u3001\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<ol>\n<li><a href=\"http:\/\/help.salesforce.com\/apex\/HTViewHelpDoc?id=formula_examples_dates.htm&amp;language=ja\" target=\"_blank\" rel=\"noopener\">\u4e00\u822c\u7684\u306a\u65e5\u4ed8\u6570\u5f0f<\/a><\/li>\n<li>\u300c\u65e5\u4ed8\/\u6642\u9593\u578b\u300d\u9805\u76ee\u3092\u548c\u66a6\u306e\u5348\u524d\u30fb\u5348\u5f8c\u8868\u793a\u306b<br \/>\n\u203b\u300c2010\/07\/30 01:28\u300d\u304c\u300c\u5e73\u621022\u5e747\u670830\u65e5 \u5348\u524d1\u664228\u5206\u300d\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n<li>\u6642\u9593(\u6642\u9593\u5e2f)\u306e\u8868\u793a<br \/>\n\u203b\u300c10:00-12:00\u300d\u3084\u300cAM\u307e\u305f\u306fPM\u300d\u306a\u3069\u3001\u3044\u308d\u3044\u308d\u306a\u5f62\u5f0f\u3067\u6642\u9593\u5e2f\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n<\/ol>\n<p>\u4ee5\u4e0a\u3001\u3054\u53c2\u8003\u306b\u306a\u308a\u307e\u3057\u305f\u3089\u5e78\u3044\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Salesforce\u306eTips\u3067\u3059\u3002\u300c\u65e5\u4ed8\/\u6642\u9593\u578b\u300d\u9805\u76ee\u306e\u6642\u9593\u5dee\u3092\u7b97\u51fa\u3059\u308b\u6570\u5f0f\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3061\u3087\u3063\u3068\u7121\u7406\u3084\u308a\u611f\u304c\u3042\u308a\u307e\u3059\u304c\u30012\u3064\u306e\u300c\u65e5\u4ed8\/\u6642\u9593\u578b\u300d\u9805\u76ee\u306e\u6642\u9593\u5dee\u3092\u5206\u5358\u4f4d\u3067\u51fa\u3057\u3066\u304f\u308c\u307e\u3059\u3002 ((DATE(VALUE(MID&#8230;<\/p>\n","protected":false},"author":99,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4039","post","type-post","status-publish","format-standard","hentry","category-salesforce"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.synergy-marketing.co.jp\/blog\/wp-json\/wp\/v2\/posts\/4039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.synergy-marketing.co.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.synergy-marketing.co.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.synergy-marketing.co.jp\/blog\/wp-json\/wp\/v2\/users\/99"}],"replies":[{"embeddable":true,"href":"https:\/\/www.synergy-marketing.co.jp\/blog\/wp-json\/wp\/v2\/comments?post=4039"}],"version-history":[{"count":3,"href":"https:\/\/www.synergy-marketing.co.jp\/blog\/wp-json\/wp\/v2\/posts\/4039\/revisions"}],"predecessor-version":[{"id":14035,"href":"https:\/\/www.synergy-marketing.co.jp\/blog\/wp-json\/wp\/v2\/posts\/4039\/revisions\/14035"}],"wp:attachment":[{"href":"https:\/\/www.synergy-marketing.co.jp\/blog\/wp-json\/wp\/v2\/media?parent=4039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.synergy-marketing.co.jp\/blog\/wp-json\/wp\/v2\/categories?post=4039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.synergy-marketing.co.jp\/blog\/wp-json\/wp\/v2\/tags?post=4039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}