My data input file has time in 24 hour notation. I can format the "time" field such that it appears in 12 hour notation as a stand-alone. However, when I try to combine this field in a calculation (generating an email message with multiple fields - in this case reminding a client of an upcoming resrevation time), the time reverts to he 24-hour notation. Any ideas?

Edited March 20, 200817 yr by Guest

See here:

http://www.fmforums.com/forum/showtopic.php?tid/193751/

Thanks for the quick response! The code you pointed me to does work . . .. sorry to be such a "newby" but, my new calc is giving me both the 24 hour and 12 hour notation. Any chance you can see my error:

==============================

"Dear " & Contact Management::First Name & ",¶¶ This message is to confirm your reservation for "&

OpenTix::Time 12 hour &Mod( Hour (Time 12 hour ) - 1 ; 12 ) + 1 & ":"

&Right ( "00" & Minute ( Time 12 hour ) ; 2 )

&Case ( Time 12 hour < 43200 ; " AM" ; " PM" ) &

I am guessing it's this part:

"Dear " & Contact Management::First Name & ",¶¶ This message is to confirm your reservation for "&

OpenTix::Time 12 hour &Mod( Hour (Time 12 hour ) - 1 ; 12 ) + 1 & ":"

&Right ( "00" & Minute ( Time 12 hour ) ; 2 )

&Case ( Time 12 hour < 43200 ; " AM" ; " PM" ) &

However, the context is not quite clear to me: why is it OpenTix::Time 12 hour in one place and Time 12 hour in another?

that was the problem . . thanks very much