Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to add hours

Currently my MSSQL column for time is past due 8hours, therefore I need to add another 8hours

eg: current 07:28:30 need to be 15:28:30

Below are the script that been tried but not meet my needs

     Time(("TMS & WMS Push Date"),'hh:mm:ss')+8:00:00

             Time(("TMS & WMS Push Date"),'hh:mm:ss')+8

Please advise.

1 Reply
Sokkorn
Master
Master

Hi,

Try this Interval('7:00:00' + '08:00:00','hh:mm:ss')

Regards,

Sokkorn