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 |
|
oasis1
Starting Member
35 Posts |
 Posted - 2012-07-05 : 22:00:38
|
| I want to be able to use the short date format on my report. I have the basic format figured out but when I come up against a null it gives me an #error? How do I rid of this? I tried Not is nothing but didn't work. mahalo, Mark |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-05 : 22:10:20
|
What is the format string you are using? Can you show your current expression? I am expecting something like this should work (although I have not tested it)=IIF(IsNothing(Fields!YourDateColumn),"",YourFormatDatePartHere) |
 |
|
|
oasis1
Starting Member
35 Posts |
Posted - 2012-07-05 : 22:14:39
|
| Much Mahalo, worked like a charm... |
|
|
|
|
|
|
Date field check for nulls and format