Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.