Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
svibuk
Yak Posting Veteran
62 Posts |
 Posted - 2012-09-29 : 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 valueif 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
52326 Posts |
Posted - 2012-10-01 : 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 varcharie likeIIf(cdate(Fields!dtfrm.Value)="01-01-1900","",Cstr(Fields!dtfrm.Value)+ " to "+CStr(Fields!dtto.Value) )------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
conditional expression using date