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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SSRS =Today()

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 do

iif( {@End} >= today(), Fields!QTYISSUE.Value, 0


I 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)
Go to Top of Page
   

- Advertisement -