hi
if we want to change the DateTime to Short date.. we will get null value as 01/01/0001
this is default value of Date.
need to use IIF condition for this.
=iif(isnothing(Fields!Confirmed_Check_In_Date.Value),"",FormatDateTime(Fields!Confirmed_Check_In_Date.Value, DateFormat.ShortDate))
if we want to change the DateTime to Short date.. we will get null value as 01/01/0001
this is default value of Date.
need to use IIF condition for this.
=iif(isnothing(Fields!Confirmed_Check_In_Date.Value),"",FormatDateTime(Fields!Confirmed_Check_In_Date.Value, DateFormat.ShortDate))