Any column display with value of 1/1/1900 12:00:00 AM even after the SQL Server Query output is correct, you need to follow the below IIF statement in expression of SSRS
SELECT [ReviewDate] AS [ReviewDate] from Tablename.
Review Date is datetime.
Solution to SSRS is: Editing the value like below. If the value is Null or Empty, the below one is a good one for that issue
=IIF(Fields!ReviewDate.Value="1/1/1900 12:00:00 AM","",Format(Fields!ReviewDate.Value,"dd-MM-yyyy"))
In SQL Server, you can use the query
SELECT isnull(Convert(Varchar(10),[ReviewDate],105),'') AS
[ReviewDate] from
TableName
However, although the above SQL display is correct, it won't help in SSRS. Therefore, one should follow the above IIF
statments, that is
=IIF(Fields!ReviewDate.Value="1/1/1900
12:00:00
AM","",Format(Fields!ReviewDate.Value,"dd-MM-yyyy"))
Normal Date
Format formula is as per below:
=Format(CDate(Fields!ReviewDate.Value),
"dd-MM-yyyy") -- Works well
