|
svibuk
Yak Posting Veteran
50 Posts |
 Posted - 09/29/2012 : 11:58:40
|
IIf(cdate(Fields!dtfrm.Value)="01-01-1900","",cdate(Fields!dtfrm.Value)+ " to "+cdate(Fields!dtto.Value) )
i used the above formula but i am not getting any value
if the date is 01-01-1900 ( in db its 1900-01-01) then it shld be blank else pint the date |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47069 Posts |
Posted - 10/01/2012 : 12:01:31
|
what are the datatypes of dtFrm and dtto in the db table?
In any case for concatenation you should make them all varchar
ie like
IIf(cdate(Fields!dtfrm.Value)="01-01-1900","",Cstr(Fields!dtfrm.Value)+ " to "+CStr(Fields!dtto.Value) )
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
Edited by - visakh16 on 10/01/2012 12:02:36 |
 |
|
conditional expression using date
