conditional display of values based on date value

Question

User-1474096950 posted

=Fields!pname.Value+ "                           " +IIf(cdate(Fields!dtfrm.Value)="01-01-1900","",cdate(Fields!dtfrm.Value)+ " to "+cdate(Fields!dtto.Value) )

i want tht if the date is 01-01-1900 then the value shld be blank else display value frm db

Answer 1

User276895905 posted

your fields!dtfrm.Value is a date object? if it is , then you need to use value.toString("MM-dd-yyyy)

Answer 2

User-1474096950 posted

using above i get wrong no of arguments

Answer 3

User-1051986203 posted

use below code :

=Fields!pname.Value+ "" + Switch(cdate(Fields!dtfrm.Value) = "01-01-1900", "",cdate(Fields!dtfrm.Value) <> "01-01-1900",cdate(Fields!dtfrm.Value)+" to "+cdate(Fields!dtto.Value))