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 |
|
sz1
Aged Yak Warrior
555 Posts |
 Posted - 2013-03-20 : 07:11:47
|
| Hi I've done loads of these now so I must be missing something sill here?Trying to sum the tickets that are 1 day less from today in an expression, I get an error with this?=sum(iif(Fields!Agreed_Solved_Date___Time.Value =DateAdd("d",-1,Today()),1,0)))Much thanksSZ1Learning and development is the driving force in the universe...! |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2013-03-20 : 07:58:06
|
| Ok this code works but counting 0 for even though there are 6 records for yesterday?=Sum(IIF(Fields!Agreed_Solved_Date___Time.Value = DateAdd("d",-1, TODAY()),1,0))SZ1Learning and development is the driving force in the universe...! |
 |
|
|
|
|
|
sum if dateadd