>>>Is there a cleaner/better way of converting a time() to a more readable format?
>>>

>>>m.DisplayTime = RIGHT(TRANSFORM(CTOT(TRANSFORM(TIME(),'@R 99999999'))),11)
>>>

>>
>>The TIME() is pretty readable. What exactly do you want to change? What format do you want time to be presented in ?
>>On my PC your expression returns the same as TIME() prefixed with '99 ' - '99 13:28:00'
>
>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.

set hours to 12
?Ttoc(datetime(),2)