topic Re: NETWORKDAYS date upside-down in QlikView https://community.qlik.com/t5/QlikView/NETWORKDAYS-date-upside-down/m-p/524423#M689454 <HTML><HEAD></HEAD><BODY><P>HHHHHHHOOOOOOOOO ¡</P><P></P><P>is very very clear, thank you</P><P></P><P>it's run&nbsp; ok </P></BODY></HTML> Thu, 14 Nov 2013 12:58:26 GMT 2013-11-14T12:58:26Z NETWORKDAYS date upside-down https://community.qlik.com/t5/QlikView/NETWORKDAYS-date-upside-down/m-p/524420#M689451 <HTML><HEAD></HEAD><BODY><P>Hello everybody..........</P><P>I have a table with dates ,&nbsp; in same case the date upside-down, The second date is minor that the first one</P><P>12-07-2013&nbsp; 30-06-2013 </P><P><SPAN lang="en"><SPAN class="atn hps" title="Fai clic per visualizzare le traduzioni alternative">the "</SPAN><SPAN title="Fai clic per visualizzare le traduzioni alternative">networkday</SPAN><SPAN title="Fai clic per visualizzare le traduzioni alternative">"</SPAN> function </SPAN> itt gives me mistake&nbsp;&nbsp;&nbsp; -1</P><P></P><DIV><P><SPAN lang="en"><SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">tobe -10</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">&nbsp; not -1<BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">Which is the solution?</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative"></SPAN></SPAN></P></DIV><P>thak you </P></BODY></HTML> Thu, 14 Nov 2013 12:45:16 GMT https://community.qlik.com/t5/QlikView/NETWORKDAYS-date-upside-down/m-p/524420#M689451 2013-11-14T12:45:16Z Re: NETWORKDAYS date upside-down https://community.qlik.com/t5/QlikView/NETWORKDAYS-date-upside-down/m-p/524421#M689452 <HTML><HEAD></HEAD><BODY><P>May be simply like this:</P><P></P><P>If( StartDatefield&gt;EndDateField, NetworkDays(EndDateField,StartDatefield) , NetworkDays(StartDatefield,EndDateField) )&nbsp; as NetWorkingDays</P></BODY></HTML> Thu, 14 Nov 2013 12:50:35 GMT https://community.qlik.com/t5/QlikView/NETWORKDAYS-date-upside-down/m-p/524421#M689452 tresB 2013-11-14T12:50:35Z Re: NETWORKDAYS date upside-down https://community.qlik.com/t5/QlikView/NETWORKDAYS-date-upside-down/m-p/524422#M689453 <HTML><HEAD></HEAD><BODY><P>Or</P><P></P><P>NetWorkDays(RangeMin(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">StartDatefield</SPAN>, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">EndDateField</SPAN>), RangeMax(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">StartDatefield</SPAN>, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">EndDateField</SPAN>))</P><P></P><P>Jonathan</P></BODY></HTML> Thu, 14 Nov 2013 12:54:14 GMT https://community.qlik.com/t5/QlikView/NETWORKDAYS-date-upside-down/m-p/524422#M689453 jonathandienst 2013-11-14T12:54:14Z Re: NETWORKDAYS date upside-down https://community.qlik.com/t5/QlikView/NETWORKDAYS-date-upside-down/m-p/524423#M689454 <HTML><HEAD></HEAD><BODY><P>HHHHHHHOOOOOOOOO ¡</P><P></P><P>is very very clear, thank you</P><P></P><P>it's run&nbsp; ok </P></BODY></HTML> Thu, 14 Nov 2013 12:58:26 GMT https://community.qlik.com/t5/QlikView/NETWORKDAYS-date-upside-down/m-p/524423#M689454 2013-11-14T12:58:26Z