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 |
|
dba123
Yak Posting Veteran
90 Posts |
 Posted - 2006-02-07 : 20:53:41
|
| I need to do this but can't find the syntax: IIf(Fields!EnteredDate.Value is in current month , Cint(Fields!PC.Value), CInt(0)) I need the syntax for this for SSRS 2005 (Reporting Services) |
|
|
jhermiz
3564 Posts |
Posted - 2006-02-08 : 07:32:04
|
=IIF(Format(Fields!EnteredDate.Value, "m"), Fields!PC.Value, 0)
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
|
|
|
Check Date expression