Wednesday 18 March 2015

SSRS Dates

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))

No comments:

Post a Comment