SQL Server Reporting Services: Date Field expression

Last Reply on Oct 02, 2012 12:47 AM By Mudassar

Posted on Oct 01, 2012 09:16 AM

in reporting services i hve the below expression

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

wht i need is displaying value of pname and then in the next line displaying date if the date is not 1900-01-01

Posted on Oct 02, 2012 12:47 AM

Read here