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 |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2005-07-28 : 17:24:30
|
| =IIF( Fields!Start_Date.Value = cstr("01/01/1900"), "X",IIF(isdbnull(Fields!Start_Date.Value),"X",""))Basically, I have to check for a smalldatetime field, and if it's "01/01/1900" or <NULL>, then the textbox has to have a value of "X" to let the user know they need to fill it in!Thanks! |
|
|
jhermiz
3564 Posts |
Posted - 2005-07-28 : 23:59:28
|
=IIF(Fields!Start_Date.Value = "01/01/1900" OR LEN(Fields!Start_Date.Value < 0, "X", "")Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-07-29 : 00:03:17
|
Sorry forgot a )=IIF(Fields!Start_Date.Value = "01/01/1900" OR LEN(Fields!Start_Date.Value) < 0, "X", "")
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2005-07-29 : 09:59:40
|
| Thanks jhermiz!Got it to work! |
|
|
|
|
|
|
Nested IIF() expression error