DateTime Parameter Adds 'AM 12:00:00'

Question

Hi,

I am using ssrs 2008.

I have a DateTime (calendar) parameter in my report.

When I browse my report directly from the Report Server there are no problems.

I have also an ASP.NET application which is located on a Web Server, this application display the report using the ReportViewer control (Version 9.0.0.0).

The problem occurs when I browse the report through the Web Server application – when I select a date from the DateTime parameter it always adds me the hour '12:00:00 AM', for example if I select 21/05/2010, it shows me     'AM 12:00:00 21/05/2010'.

I tried to set the report language (in the .rdl file to – '=User!Language') but it does not solve the problem.

I know it is possible to change the date format in the 'regional and language options' but I don’t know what I should change.

How can I remove the hour from my DateTime parameter – for the user will not see it?  

Any help will be appreciated.

Answer 1

It looks like report viewer bug. I guess this datetime parameter is from a query. So try to create another label column for actual time and then you can totally control how to display datetime.

---

Have fun with Reporting Service

Answer 2

 

This Date Time is not from query, the user selects it from the DateTime parameter (calendar control).

I deployed the application I mentioned above to other web server, and it does not happen from there.

But it still happens on the original web server.

Should I check anything special on the web server – what can cause this behavior?

 

Answer 3

Hello,

If you are displaying in the report then use this expression.
=FORMAT(Paremeters!DateParameter.Value,"MM/dd/yyyy")

Hope its clear....

---

Pavan Kokkula Infosys Technologies Limited.

Answer 4

I don’t display the date in my report, as I said the user selects it from the DateTime parameter (calendar control) – and it automatically adds me hour "AM 12:00:00".

I just don’t want the hour to be displayed in the parameter itself.

Why does it add hour "AM 12:00:00" automatically?

Answer 5

use formatedatetime while displaying datetime value 

Answer 6

 

Hi Razyee,

How can I use formatedatetime while displaying datetime value, to format the datetime displayed in the parameter itself?

Answer 7

 

I do not think it is possible to format a DateTime parameter value in the parameter itself.....

Is it possible? how?