Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Covert hh:mm:ss to Days hh:mm:ss

Hi,

I have a field called Fix_date_true, which currently pulls out a time format such as 73:01:24 (hh:mm:ss).  However I want to be able to convert this date into Days hh:mm:ss, so the above will show : 2 01:01:24 (This will shows 2 Days 01 Hour 01 Minutes and 24 Seconds).  Is this possible in an Expression.

Regards,

Jon Ditchfield

1 Solution

Accepted Solutions
Gysbert_Wassenaar

interval(Fix_date_true, 'D hh:mm:ss') or perhaps interval(interval#(Fix_date_true, 'hh:mm:ss'), 'D hh:mm:ss'). Depends on what data type Fix_date_true has.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

interval(Fix_date_true, 'D hh:mm:ss') or perhaps interval(interval#(Fix_date_true, 'hh:mm:ss'), 'D hh:mm:ss'). Depends on what data type Fix_date_true has.


talk is cheap, supply exceeds demand