DO CASE CASE LEFT(lcTime,2) = "00" lcNewTime = STUFF(lcTime,1,2,"12") + " AM" CASE LEFT(lcTime,2) < "12" lcNewTime = lcTime + " AM" CASE LEFT(lcTime,2) > "12" lcNewTime = PADL(INT(VAL(lcTime)-12),2,"0") + RIGHT(lcTime,6) + " PM" OTHERWISE lcNewTime = lcTime + " PM" ENDCASE ? lcNewTime>Mine returns:
>14:03:13 >>I need:
>02:03:13 PM >>I'm sure it's due to the environmental settings, but that's what they are set to.