Hi all below is list of Date/Time which is my output in SQL Management Studio.

When I move this into SSRS and use the DateTime custom function it shows the the Date/Time correctly if there is a time element. However it's defaulting the 00:00:00.000 to 12:00:00 PM which is incorrect. Is there a fix around this.

I would like the SSRS to show as Format dd/MM/yyyy hh:mm but still show the 00:00 element.

DTTMOFDEATH
2015-05-15 00:00:00.000
2015-05-13 00:00:00.000
2015-05-28 09:30:00.000
2015-06-04 00:00:00.000
2015-05-19 00:00:00.000
2015-01-12 00:00:00.000
2014-12-26 00:00:00.000
2015-03-22 00:00:00.000
2015-06-19 17:40:00.000
2015-06-12 00:00:00.000
2015-06-12 13:31:00.000
2015-06-19 06:50:00.000
2015-06-03 00:00:00.000
2015-06-21 23:10:00.000
2015-04-09 00:00:00.000
2015-05-13 00:00:00.000
2015-01-29 00:00:00.000
2015-03-27 00:00:00.000
2015-05-21 00:00:00.000

Hello,

You can use Custom Date and Time Format Strings to format the value as you prefer.

Right click on it and click on Text Box properties as the picture below:

And choose the format that you need.

Hope it helps!!

Thats the way datetime works in SQLServer. A time part of 00:00:00 means 12 midnight which is what is displayed as 12:00 AM

In your case didnt understand why you got it as 12:00PM

anyways you can change format as 00:00:00 then use expression as below

Format(Fields!FieldName.Value,"yyyy-MM-dd hh:mm:ss")

Hi, 

According to your description, you want to format the time part in date to 12:00:00 PM, right?

In your scenario, you can fix the time part in the format string within Format() function, please refer to the following expression to get the expected date format. 

=CDate(Format(Fields!date.Value,"dd-MM-yyyy 12:00:00") & " PM")

If you have any question, please feel free to ask. 

Regards, 
Shrek Li