topic Re: Day Offset ? in QlikView https://community.qlik.com/t5/QlikView/Day-Offset/m-p/1003585#M340996 <HTML><HEAD></HEAD><BODY><P>Thanks Avinash,</P><P></P><P>Here is the scenario that I am looking for: </P><P></P><P>let say in my organization I have 3 shifts </P><P>shift 1 starts at 7 am every day and ends at 1.59 PM</P><P>Shift2 starts at&nbsp; 2 PM to 9.59 PM</P><P>Shift3 Starts at 10 PM to 6:59 AM next day</P><P></P><P>however these there shifts belongs to same day , to map this I need day offset. could please help me on this.</P></BODY></HTML> Tue, 06 Oct 2015 07:48:15 GMT 2015-10-06T07:48:15Z Day Offset ? https://community.qlik.com/t5/QlikView/Day-Offset/m-p/1003582#M340993 <HTML><HEAD></HEAD><BODY><P>Hi Qlikheads</P><P></P><P>can any one help me on how to get the Day offset in hours , means</P><P></P><P>one day will have 24 hours, day starts from 00.00 AM, every day but I want&nbsp; a date which is having offset of +7 hours</P><P></P><P>Day has start at 7 am every day and ends at 6:59 AM</P><P></P><P>how to achieve this?</P><P></P><P>Regards</P><P>John</P></BODY></HTML> Tue, 06 Oct 2015 07:37:35 GMT https://community.qlik.com/t5/QlikView/Day-Offset/m-p/1003582#M340993 2015-10-06T07:37:35Z Re: Day Offset ? https://community.qlik.com/t5/QlikView/Day-Offset/m-p/1003583#M340994 <HTML><HEAD></HEAD><BODY><P>I didn't get why you need like this? can you explain bit more on the requirement </P></BODY></HTML> Tue, 06 Oct 2015 07:42:09 GMT https://community.qlik.com/t5/QlikView/Day-Offset/m-p/1003583#M340994 avinashelite 2015-10-06T07:42:09Z Re: Day Offset ? https://community.qlik.com/t5/QlikView/Day-Offset/m-p/1003584#M340995 <HTML><HEAD></HEAD><BODY><P>May be like:</P><P></P><P>Date(DateTimeStamp - 7/24) as NewDate</P></BODY></HTML> Tue, 06 Oct 2015 07:46:40 GMT https://community.qlik.com/t5/QlikView/Day-Offset/m-p/1003584#M340995 tresB 2015-10-06T07:46:40Z Re: Day Offset ? https://community.qlik.com/t5/QlikView/Day-Offset/m-p/1003585#M340996 <HTML><HEAD></HEAD><BODY><P>Thanks Avinash,</P><P></P><P>Here is the scenario that I am looking for: </P><P></P><P>let say in my organization I have 3 shifts </P><P>shift 1 starts at 7 am every day and ends at 1.59 PM</P><P>Shift2 starts at&nbsp; 2 PM to 9.59 PM</P><P>Shift3 Starts at 10 PM to 6:59 AM next day</P><P></P><P>however these there shifts belongs to same day , to map this I need day offset. could please help me on this.</P></BODY></HTML> Tue, 06 Oct 2015 07:48:15 GMT https://community.qlik.com/t5/QlikView/Day-Offset/m-p/1003585#M340996 2015-10-06T07:48:15Z