AM PM format

How can I show time portion of a date in "hh:mm:ss" AM?PM format?
ThanksIn the format property for a textbox use the following:
hh:mm:ss tt
HTH
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Mark Goldin" wrote:
> How can I show time portion of a date in "hh:mm:ss" AM?PM format?
> Thanks
>
>|||What Language setting have you used on the Report?
Click on the Report Property and look for Language. Set it to English
(United States)
Then click on a textbox with a time datatype in, and set T as format. Now
you have am/pm.
If you don't want to change the language of the whole report, you'll have to
use some formating function on the expression. Or change the format in your
query, to make it return the time in the correct format from your data
source.
Kaisa M. Lndahl Lervik
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:utU3$sP3GHA.3428@.TK2MSFTNGP05.phx.gbl...
> How can I show time portion of a date in "hh:mm:ss" AM?PM format?
> Thanks
>