>How can I convert the following to non-military time? And yes, before the jokes start, the "13:45" is a value in an array. I can't just retype it to "1:45" instead. Thanks!
>
>
>(RIGHT( "0" + ALLTRIM( "13:45" ), 5 ))
>
lctime = "13:45"
? IIF(VAL(lctime)>11,TRANSFORM(VAL(lctime)-12)+RIGHT(lctime,3)+[ PM],lctime+[ AM])
lctime = "11:45"
? IIF(VAL(lctime)>11,TRANSFORM(VAL(lctime)-12)+RIGHT(lctime,3)+[ PM],lctime+[ AM])
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst