{"id":2486,"date":"2015-05-27T07:00:50","date_gmt":"2015-05-26T22:00:50","guid":{"rendered":"http:\/\/www.jimuya.com\/?p=2486"},"modified":"2015-05-27T06:16:14","modified_gmt":"2015-05-26T21:16:14","slug":"%e3%82%a8%e3%82%af%e3%82%bb%e3%83%ab%e3%81%a7%e6%96%87%e5%ad%97%e5%88%97%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e6%97%a5%e4%bb%98%e3%83%87%e3%83%bc%e3%82%bf%e3%81%ab%e5%a4%89%e6%8f%9b%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.jimuya.com\/?p=2486","title":{"rendered":"\u30a8\u30af\u30bb\u30eb\u3067\u6587\u5b57\u5217\u30c7\u30fc\u30bf\u3092\u65e5\u4ed8\u30c7\u30fc\u30bf\u306b\u5909\u63db\u3059\u308b\u306b\u306f"},"content":{"rendered":"

\u30a8\u30af\u30bb\u30eb\u3092\u4f7f\u3063\u3066\u3044\u3066\u3001<\/p>\n

\u65e5\u4ed8\u306e\u5e74\u3001\u6708\u3001\u65e5\u304c\u5225\u306e\u30bb\u30eb\u306b\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001<\/p>\n

\u4e00\u3064\u306e\u30bb\u30eb\u306b\u307e\u3068\u3081\u3066\u65e5\u4ed8\u30c7\u30fc\u30bf\u3068\u3057\u3066\u8868\u793a\u3055\u305b\u305f\u3044\u3002<\/p>\n

\u3068\u3044\u3046\u3053\u3068\u304c\u3042\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\u5e74\u3001\u6708\u3001\u65e5\u304c\u305d\u308c\u305e\u308c\u5206\u304b\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u7c21\u5358\u3067\u3059\u3002<\/p>\n

DATE\u95a2\u6570\u3092\u4f7f\u3044\u3001<\/p>\n

DATE(\u5e74\u306e\u30bb\u30eb,\u6708\u306e\u30bb\u30eb,\u65e5\u306e\u30bb\u30eb\uff09<\/p>\n

\u3068\u5165\u529b\u3059\u308b\u3068\u65e5\u4ed8\u30c7\u30fc\u30bf\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\u3055\u3066\u3001\u3053\u3053\u3067\u554f\u984c\u3002<\/p>\n

\u5e74\u304c\u897f\u66a6\u306e\u5834\u5408\u306fDATE\u95a2\u6570\u3067\u89e3\u6c7a\u3067\u304d\u307e\u3059\u304c\u3001<\/p>\n

\u548c\u66a6\u306e\u5834\u5408\u306f\u6b63\u3057\u304f\u8868\u793a\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n

 <\/p>\n

\u5e73\u6210\u4f55\u5e74\u3068\u3044\u3046\u30c7\u30fc\u30bf\u3057\u304b\u306a\u3044\u5834\u5408\u306f<\/p>\n

\u5e74\u306b1988\u3092\u305f\u3059\u3068\u3044\u3046\u8352\u696d\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n

\u95a2\u6570\u304c\u82e6\u624b\u306a\u4eba\u306b\u5411\u3044\u3066\u3044\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n

 <\/p>\n

\u95a2\u6570\u3092\u4f7f\u3046\u5834\u5408\u306f<\/p>\n

\u3053\u306e\u5834\u5408\u306fDATEVALUE\u95a2\u6570\u3092\u4f7f\u3044\u307e\u3057\u3087\u3046\u3002<\/p>\n

\u30c1\u30e7\u30c3\u30c8\u8907\u96d1\u3067\u3059\u304c\u3001\u5e73\u6210\u3057\u304b\u306a\u3044\u5834\u5408\u306e\u5f0f\u306f\u3053\u3046\u3067\u3059\u3002<\/p>\n

=DATEVALUE(“h”&\u5e74\u306e\u30bb\u30eb&”\/”&\u6708\u306e\u30bb\u30eb&”\/”&\u65e5\u306e\u30bb\u30eb)<\/p>\n

\u6700\u521d\u306eh\u306f\u5e73\u6210\u306eh\u3067\u3059\u3002<\/p>\n

\u662d\u548c\u306e\u5834\u5408\u306fS\u3001\u5bfe\u8c61\u306e\u5834\u5408\u306fT\u3092\u3064\u3051\u307e\u3057\u3087\u3046\u3002<\/p>\n

\uff06\u3092\u4f7f\u3063\u3066\u65e5\u4ed8\u30c7\u30fc\u30bf\u3092\u7d50\u5408\u3057\u3066\u4f5c\u308b\u3068\u3044\u3046\u5f0f\u3067\u3059\u3002<\/p>\n

 <\/p>\n

\u65e5\u4ed8\u30c7\u30fc\u30bf\u306e\u52a0\u5de5\u3067\u56f0\u3063\u305f\u5834\u5408\u306e\u53c2\u8003\u306b\u3069\u3046\u305e\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u30a8\u30af\u30bb\u30eb\u3092\u4f7f\u3063\u3066\u3044\u3066\u3001 \u65e5\u4ed8\u306e\u5e74\u3001\u6708\u3001\u65e5\u304c\u5225\u306e\u30bb\u30eb\u306b\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001 \u4e00\u3064\u306e\u30bb\u30eb\u306b\u307e\u3068\u3081\u3066\u65e5\u4ed8\u30c7\u30fc\u30bf\u3068\u3057\u3066\u8868\u793a\u3055\u305b\u305f\u3044\u3002 \u3068\u3044\u3046\u3053\u3068\u304c\u3042\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u3002   \u5e74\u3001\u6708\u3001\u65e5\u304c\u305d\u308c\u305e\u308c\u5206\u304b\u308c\u3066 … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1518],"tags":[182,2364,77,76,1510,149,2368,2372,33,2366,1247,2367,2365,2369,2370,2371,180],"class_list":["post-2486","post","type-post","status-publish","format-standard","hentry","category-pc_excel","tag-date","tag-datevalue","tag-excel","tag-76","tag-1510","tag-149","tag-2368","tag-2372","tag-33","tag-2366","tag-1247","tag-2367","tag-2365","tag-2369","tag-2370","tag-2371","tag-180"],"_links":{"self":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/posts\/2486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2486"}],"version-history":[{"count":0,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/posts\/2486\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}