24-hour time format

I need to display a datetime in the following format:
31-10-2006 23:15:05 (day, month year with 24-hour time format).
I have tried this:
=Format(Fields!Date_Logged.Value,"dd-MM-yyyy hh:mm:ss")
but it shows the hour as 8:00 for AM and 8:00 for PM. I do NOT want to use
AM and PM (I know that would be 'tt' at the end), because I live in Denmark,
where 24-hours is used. How do I get the 24-hour hours to show?
Thanks in advance for any tips.You are very close. Just put the following in the format code exactly as I
have here:
MM/dd/yy HH:mm:ss
Also, although you can use the expression like you have done below, you
don't need to. Just put the expression code is, no = sign, no quotes.
Same thing for formatting numbers. I use this quite a bit
#,##0
The canned formats don't have this which I prefer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"yogi bear" <yogi bear@.discussions.microsoft.com> wrote in message
news:DC1A6B4A-00FB-4617-9098-28BB2830E957@.microsoft.com...
>I need to display a datetime in the following format:
> 31-10-2006 23:15:05 (day, month year with 24-hour time format).
> I have tried this:
> =Format(Fields!Date_Logged.Value,"dd-MM-yyyy hh:mm:ss")
> but it shows the hour as 8:00 for AM and 8:00 for PM. I do NOT want to use
> AM and PM (I know that would be 'tt' at the end), because I live in
> Denmark,
> where 24-hours is used. How do I get the 24-hour hours to show?
> Thanks in advance for any tips.
>