Time shifting by few hours

[glatocha]

Hi all,

all my data in my system database are stored in the UTC format. When I import it to Qlik I can use convert to local time function, but on top of this I need to shift the time by few hours as the customer expects the "daily" reports from 8am to 8am next day. Is there a function to shift it by hours? 

[Vegar]

You can use DayName() and its 3rd parameter to specify an offset to change when a day start.

Try something like this.

Dayname(YourDateValue, 0, 1/3) as YourAdjustedDateValue