Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe
Interval('1805:53','dd:hh:mm') -> 75:05:53
Regards,
Antonio
Says error in expression so doesn't work.
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;
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')
Just to confirm, it worked for me also
Thanks guys it works great now.:)