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 |
|
Vack
Aged Yak Warrior
530 Posts |
 Posted - 2014-11-17 : 13:11:36
|
| I can't seem to use Today() in a calculated field. I'm trying to doiif( {@End} >= today(), Fields!QTYISSUE.Value, 0I get incorrect Syntax with the red line under the () |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-17 : 13:28:01
|
The function is Now() I believe. But there are other problems. Here's a working example. I set up a parameter called Today defined with the expression =Now() then use it like this:=IIf(Parameters!Today.Value = #11/17/2014#, "today", "other day") I don't think you can use {@End} at all. Also, your closing parenthesis is missing) |
 |
|
|
|
|
|
SSRS =Today()