>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,
Try this;
FUNCTION ConvTime(pcTime)
LOCAL lnHours
lnHours = VAL(LEFT(pcTime,2))
IF lnHours > 12
lnHours = lnHours - 12
pcTime = PADL(ALLTRIM(STR(lnHours,2)),2,"0") + SUBSTR(pcTime,3)
ENDIF
RETURN pcTime