Datetime Problem - 24 Hour Clock

[monkeybarfan]

I have stored procedures, which display data perfectly in 15 minute interval blocks

eg
17 May 2009 00:00:00
17 May 2009 00:15:00
17 May 2009 00:30:00
etc etc

However, when I run the report in Reporting Services the 00 has changed to 12

eg
17 May 2009 12:00:00
17 May 2009 12:15:00
17 May 2009 12:30:00

01:00:00 changes to 13:00:00 etc

Also, when I input a date using the calendar component it changes it. for example, if I choose 12/05/2009 (12th May as I am in UK) it changes it to 05/12/2009 (5th December).

I have checked my regional settings in control panel and everything is set to UK or eng-gb where required. In Visual Studio, I have ensured that Tools-Options-International Settings is set to "Same as Microsoft Windows". The problem is that when I deploy these reports to the report server, they are causing the problem for the end users too.

Any ideas anyone?

 

[xlbo]

1: Set format for display to dd/MMM/yyyy hh:mm:ss

Ensure that it does not have "PM" at the end

2: Check date settings on report server and server where database that is providing your data resides

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[monkeybarfan]

I solved the time problem, it was because i needed to put HH:mm:ss instead of hh:mm:ss

However, the dates swapping around I haven't solved. This only happens when previewing the report in Visual Studio. When I change the parameters on the report server web interface it works ok.