Convert Numeric to Time

[mistektips]

Hi,
There is a field which represents time, got from As400 table which is in numeric format(4283002). I want to convert this to time format(04:28:30) using vb scripts. Is there any cast function which will do this?

 

[PHV]

Have a look at the TimeSerial and Mid functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886