topic Date range comparison in QlikView https://community.qlik.com/t5/QlikView/Date-range-comparison/m-p/171100#M41249 <HTML><HEAD></HEAD><BODY><P>Hi prezmek,</P><P>Can you please elaborate your question. Make it clear.</P><P>thanks Joseph....</P></BODY></HTML> Mon, 31 May 2010 12:04:19 GMT 2010-05-31T12:04:19Z Date range comparison https://community.qlik.com/t5/QlikView/Date-range-comparison/m-p/171099#M41248 <HTML><HEAD></HEAD><BODY><P>Dear All, to get day/night working hours I'd like to compare actual working StartTime - EndTime range with 22:00 - 6:00 range e.g.</P><P></P><P style="font-weight: bold">StartTime, EndTime, DayHours, NightHours</P><P>7:00, 15:00, 8, 0</P><P>5:00, 23:00, 16, 2</P><P>23:00, 7:00, 1, 7</P><P></P><P>Any idea how to compare the ranges?</P><P>BR, Przemek</P></BODY></HTML> Mon, 31 May 2010 10:45:29 GMT https://community.qlik.com/t5/QlikView/Date-range-comparison/m-p/171099#M41248 2010-05-31T10:45:29Z Date range comparison https://community.qlik.com/t5/QlikView/Date-range-comparison/m-p/171100#M41249 <HTML><HEAD></HEAD><BODY><P>Hi prezmek,</P><P>Can you please elaborate your question. Make it clear.</P><P>thanks Joseph....</P></BODY></HTML> Mon, 31 May 2010 12:04:19 GMT https://community.qlik.com/t5/QlikView/Date-range-comparison/m-p/171100#M41249 2010-05-31T12:04:19Z Date range comparison https://community.qlik.com/t5/QlikView/Date-range-comparison/m-p/171101#M41250 <HTML><HEAD></HEAD><BODY><P>Let's say you worked in Day1 from 21:00 to 5:30 (9pm - 5:30am) and in Day2 from 9:00 to 17:00 (9am - 5pm). So, according to day/night hours rules (day hours: 6:00-22:00, night hours: 22:00-6:00) you worked 1 day hour and 7,5 night hrs in Day1 and 8 day hours in Day2. Is this clear now?</P><P></P><P>BR, Przemek</P></BODY></HTML> Mon, 31 May 2010 13:02:18 GMT https://community.qlik.com/t5/QlikView/Date-range-comparison/m-p/171101#M41250 2010-05-31T13:02:18Z