Simple Hour() question

[omacron]

Hi

I am sure making this harder then it is. I need to display the hour of a datetime field, problem is that;

Hour(Table.Date)

is giving it to me in military time. I want to display it with AM/PM on it. Been looking around and can't find anything on how to do this. I could do something like this;

select Hour(Table.Date)
        case 1:
             "1 AM"
....

This seems silly to me and there has to be an easier way.

thanks

 

[lbass]

totext({table.datetime}, "h tt")

-LB