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

Changing hh:mm to dd:hh:mm date format

Hi guys

I have tried a lot of options for changing hh:mm to dd:hh:mm.

Existing format example

1805:53

That's reading as 1805 hours and 53 minutes.

Need days and hours and minutes combined.

Please help.

Thanks

6 Replies
antoniotiman
Master III
Master III

Maybe

Interval('1805:53','dd:hh:mm')   -> 75:05:53

Regards,

Antonio

Not applicable
Author

Says error in expression so doesn't work.

Chanty4u
MVP
MVP

try this

ta:

LOAD * INLINE [

    name, CALL_DATETIME, sales

    aa,1805:55,100

];

Result:

LOAD *,

trim(date(date(CALL_DATETIME,'hh:mm'),'dd:hh:mm ') )

AS [Call Date]

Resident ta;

frac.PNG

rubenmarin

It works for me, and returns the correct result.

In case it has something to do with the formats, try with:

=Interval(Interval#('1805:53', 'hh:mm'),'dd:hh:mm')

sunny_talwar

Just to confirm, it worked for me also

Capture.PNG

Not applicable
Author

Thanks guys it works great now.:)