{"author_name":"ch3cooh393","published":"2004-04-16 22:40:31","type":"rich","description":"(2011/12/24 \u8ffd\u8a18) \u65e7\u30d6\u30ed\u30b0\u304b\u3089\u8a18\u4e8b\u3092\u79fb\u884c\u3057\u3066\u3044\u307e\u3059\u3002 \u5165\u793e\u3057\u3066\u304b\u3089\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u306e\u51fa\u6765\u306a\u3044\u6700\u521d\u306e1\u9031\u9593\u76ee\u306b\u4f5c\u3063\u305f\u7d4c\u8cbb\u691c\u7d22\u8868\u793a\u30bd\u30d5\u30c8\u304c\u6765\u9031\u306e26\u65e5\u306e\u6708\u66dc\u65e5\u7d0d\u54c1\u306b\u306a\u308a\u307e\u3057\u305f\u3002 \u3093\u3067\u3001\u540c\u65e5\u30c7\u30e2\u30f3\u30b9\u30c8\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u3057\u3066\u3053\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\u3002\u30c7\u30e2\u306e\u6642\u306b\u5ba2\u5148\u3067\u6065\u3092\u63bb\u304d\u305f\u304f\u306a\u3044\u306e\u3067\u4eca\u5fb9\u5e95\u7684\u306b\u30d0\u30b0\u53d6\u308a\u306b\u304b\u304b\u3063\u3066\u307e\u3059\u3002 \uff11\uff0e\u3042\u308a\u3048\u306a\u3044\u5e74\u6708\u3092\u5165\u529b\u3067\u304d\u308b \u5165\u529b\u898f\u5236\u306b\u3066\u5bfe\u51e6\u3002 \u6700\u5c0f\u5e74\u3092YEAR(MIN())\u95a2\u6570\u3067\u53d6\u308a \u6700\u5927\u6708\u3092MONTH(MAX())\u95a2\u6570\u3067\u53d6\u308b \u3053\u3068\u3067\u89e3\u6c7a \uff12\uff0e\u904e\u53bb\u306b\u623b\u308b\u3088\u3046\u306a\u691c\u7d22\u306f\u304b\u308b\u3068\u843d\u3061\u308b\u30d0\u30b0\uff08\u5e74\uff09 if(StrComp(\u59cb\u5e74\u6708.\u5e74, \u7d42\u5e74\u6708.\u5e74)) = 1 \u30a8\u30e9\u30fc\u51e6\u7406\u306b\u3066\u5bfe\u5fdc \uff13.\u904e\u2026","url":"https://blog.ch3cooh.jp/entry/2004/04/16/224031","categories":["\u958b\u767a-Excel","\u958b\u767a"],"blog_title":"\u9162\u308d\u3050\uff01","author_url":"https://blog.hatena.ne.jp/ch3cooh393/","image_url":null,"height":"190","title":"\u30a8\u30af\u30bb\u30eb\u3067\u4f5c\u3063\u305f\u7d4c\u8cbb\u691c\u7d22\u8868\u793a\u30bd\u30d5\u30c8\u306e\u30d0\u30b0\u4e00\u89a7","provider_url":"https://hatena.blog","width":"100%","version":"1.0","provider_name":"Hatena Blog","blog_url":"https://blog.ch3cooh.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.ch3cooh.jp%2Fentry%2F2004%2F04%2F16%2F224031\" title=\"\u30a8\u30af\u30bb\u30eb\u3067\u4f5c\u3063\u305f\u7d4c\u8cbb\u691c\u7d22\u8868\u793a\u30bd\u30d5\u30c8\u306e\u30d0\u30b0\u4e00\u89a7 - \u9162\u308d\u3050\uff01\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}