Filter Syntax in Report Studio

[udaykamble]

[Business View].[ProjectSpread].[Start Date] > [Business View].[Project].[Data Date] And [Business View].[ProjectSpread].[End Date] <= dateadd (day,43,[Business View].[Project].[Data Date])

The above statement in filter is giving an error. I think I am missing something in syntax. Please help.

 

[sln007]

uday...,

Try using: _add_days(date-exp, integer)

[Business View].[ProjectSpread].[End Date] <= _add_days([Business View].[Project].[Data Date],43)




SLN

 

[udaykamble]

Thanks a lot. It worked.