Can anyone tell me how to convert an AS400 Time Stamp to "proper" time. I need to group a report on working hours but I can't seem to get this to work. I thought I had it using:
Time (val(left(totext({HMEEXTRL.CHGTM},0,""),2)),val(mid(totext({HMEEXTRL.CHGTM},0,""),3,2))
,val(mid(totext({HMEEXTRL.CHGTM},0,""),5,2)))
but the AS400 time for 08:00am shows as 84941 so when the above formula runs it returns an error as it's looking for an hour of 84. I'm on CR XI and any help would be much appreciated.
Time (val(left(totext({HMEEXTRL.CHGTM},0,""),2)),val(mid(totext({HMEEXTRL.CHGTM},0,""),3,2))
,val(mid(totext({HMEEXTRL.CHGTM},0,""),5,2)))
but the AS400 time for 08:00am shows as 84941 so when the above formula runs it returns an error as it's looking for an hour of 84. I'm on CR XI and any help would be much appreciated.