Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I didn't get why you need like this? can you explain bit more on the requirement
May be like:
Date(DateTimeStamp - 7/24) as NewDate
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.