Determine AM / PM from Time value

[c8ltgkue]

Hello All

Useing CR XI

I have a time field in my database which is stored in 24 hour clock formate (i.e 13:11:00) I want to find am / pm from time. Does any one know the function for this ?

Thanks in Advance.

C8

 

[lbass]

totext({table.date},"tt")

...will return AM or PM. It can be used in formatting like this also:

totext({table.date},"MM/dd/yyyy hh:mm:ss tt")

-LB