>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
set hours to 12
lcTime = '133245'
? StrTran(Left(Right(ttoc(ctot('^2000/1/1 ' + trans(lcTime, "@R 99:99:99"))), 11), 8), ":", "")
kenweber
GCom2 Solutions
Microsoft Certified Professional