=IIF( CDATE( IIF( TRIM(Fields!FldName.Value).ToString().Length = 0,"1/1/0001" ,Fields!FldName.Value)).ToString() = CDATE("01/01/0001"), "" ,Format(CDATE(IIF(TRIM(Fields!FldName.Value).ToString().Length = 0,"1/1/0001",Fields!FldName.Value)), "dd/MM/yyyy"))
Monday, February 24, 2020
Prevent RDLC Conversion Error
=IIF( CDATE( IIF( TRIM(Fields!FldName.Value).ToString().Length = 0,"1/1/0001" ,Fields!FldName.Value)).ToString() = CDATE("01/01/0001"), "" ,Format(CDATE(IIF(TRIM(Fields!FldName.Value).ToString().Length = 0,"1/1/0001",Fields!FldName.Value)), "dd/MM/yyyy"))
Subscribe to:
Comments (Atom)