>>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.