the source data has a value like "83459 " which really should be 083459 and I should represent as 8:34:59. How to accomplish that?
The field is ClosedTime
Num(ClosedTime,'000000') as ClosedTimeNum,
Time(Time#(Num(ClosedTime,'000000'),'hhmmss'),'hh:mm:ss') as ClosedTime
Use the below exp:
You can variablize or use a field instead.
Retrieving data ...