Day Offset ?

[#1]

Hi Qlikheads

can any one help me on how to get the Day offset in hours , means

one day will have 24 hours, day starts from 00.00 AM, every day but I want  a date which is having offset of +7 hours

Day has start at 7 am every day and ends at 6:59 AM

how to achieve this?

Regards

John

[avinashelite]

I didn't get why you need like this? can you explain bit more on the requirement

[tresesco]

May be like:

Date(DateTimeStamp - 7/24) as NewDate

[#4]

Thanks Avinash,

Here is the scenario that I am looking for:

let say in my organization I have 3 shifts

shift 1 starts at 7 am every day and ends at 1.59 PM

Shift2 starts at  2 PM to 9.59 PM

Shift3 Starts at 10 PM to 6:59 AM next day

however these there shifts belongs to same day , to map this I need day offset. could please help me on this.