I have a report where I need to remove the time from a datetime column. I've found this expression to work but it changes all the null values to '1/1/0001'
=FormatDateTime(Fields!Temperature_Control_Inspection_Date.Value,DateFormat.ShortDate)
I have tried the below expression to look for nulls but it doesn't appear to work.
=IIF(Fields!Temperature_Control_Inspection_Date is nothing, nothing, FormatDateTime(Fields!Temperature_Control_Inspection_Date.Value,DateFormat.ShortDate))
How can I show just the Date from a DateTime column without also having all the nulls replaced by '1/1/0001'?
=IIf(IsNothing(Fields!Temperature_Control_Inspection_Date.Value), "", FormatDateTime(Fields!Temperature_Control_Inspection_Date.Value, DateFormat.ShortDate))