I have tried a lot of options for changing hh:mm to dd:hh:mm.
Existing format example
That's reading as 1805 hours and 53 minutes.
Need days and hours and minutes combined.
Interval('1805:53','dd:hh:mm') -> 75:05:53
Says error in expression so doesn't work.
It works for me, and returns the correct result.
In case it has something to do with the formats, try with:
Just to confirm, it worked for me also
LOAD * INLINE [
name, CALL_DATETIME, sales
trim(date(date(CALL_DATETIME,'hh:mm'),'dd:hh:mm ') )
AS [Call Date]
Thanks guys it works great now.:)
Retrieving data ...