P.S., since you are in Telecom, you should try to make a case for only working with military time. Having been in the industry before, it is much more efficient and easier to deal with when going acroos time zones. Even better is GMT with a conversion routine.
>Since military time is the same before noon, you could always build an algorithm checking the first 2 digits in relation to 12. I think there is at least one time handling class in the files section, also.
>
>>I have a time field that is a character field.
>>It is length 6 and in the format hhmmss.
>>The problem is that it is in military time and I need it in standard time,, so 133245 would need to be 013245.
>>I am not sure how to convert it.
>>Thanks for any help,
>>Ryan
Michael Helms
May the Schwartz be with you.<(©¿©)> -- Mel Brooks
"Someday, and that day may never come, you will be called upon to perform a service" -- Vito Corleone
"Live like there is no tomorrow, Dance like no one is watching, Love like you've never been hurt." -- Anonymous
"I'm thinking about joining the campaign for shorter tag lines." -- Me