{"id":1362,"date":"2018-11-11T20:26:45","date_gmt":"2018-11-11T18:26:45","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1362"},"modified":"2018-11-11T20:26:45","modified_gmt":"2018-11-11T18:26:45","slug":"diffdate-bez-swiat-oraz-weekendow","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1362","title":{"rendered":"DIFFDATE bez \u015bwi\u0105t oraz weekend\u00f3w"},"content":{"rendered":"<p>Mamy dwie daty rozpocz\u0119cia i zako\u0144czenia. Chcemy wyliczy\u0107 r\u00f3\u017cnice w dniach pomijaj\u0105c \u015bwi\u0119ta oraz weekendy.<\/p>\n<p>1. Nale\u017cy utworzy\u0107 tabele ze \u015bwi\u0119tami.<br \/>\n2. Tabele z Kalendarzem po\u0142\u0105czy\u0107 z tabel\u0105 \u015bwi\u0119ta.<br \/>\n&#8211; Tabela kalendarza musi mie\u0107 kolumn\u0119 dzie\u0144 tygodnia<br \/>\n&#8211; dodajemy kolumn\u0119 \u015bwi\u0119to Holiday = RELATED(Holiday[Holiday])<br \/>\nNast\u0119pnie na podstawie w\/w kolumn liczmy czy dzie\u0144 roboczy:<br \/>\nIf work day = IF(OR(&#8217;Calendar'[Day of Week]=5;&#8217;Calendar'[Day of Week]=6);0;IF(ISBLANK(&#8217;Calendar'[Holiday]);1;0))<br \/>\n3. Nast\u0119pnie w tabeli gdzie mamy daty rozpocz\u0119cia i zako\u0144czenia wyliczamy czas trwania<br \/>\nDni robocze= CALCULATE(SUM(&#8217;Calendar'[If work day]);DATESBETWEEN(&#8217;Calendar'[Data];zad[od];zad[do]))<\/p>\n<p>Luko<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mamy dwie daty rozpocz\u0119cia i zako\u0144czenia. Chcemy wyliczy\u0107 r\u00f3\u017cnice w dniach pomijaj\u0105c \u015bwi\u0119ta oraz weekendy. 1. Nale\u017cy utworzy\u0107 tabele ze \u015bwi\u0119tami. 2. Tabele z Kalendarzem po\u0142\u0105czy\u0107 z tabel\u0105 \u015bwi\u0119ta. &#8211; Tabela kalendarza musi mie\u0107 kolumn\u0119 dzie\u0144 tygodnia &#8211; dodajemy kolumn\u0119 &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1362\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[259,258],"tags":[261,260],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1362"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1362"}],"version-history":[{"count":1,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1362\/revisions"}],"predecessor-version":[{"id":1363,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1362\/revisions\/1363"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}