SQL Reporting Servies

[Ucaihc]

I am creating quarterly report using SQL Reporting Services and I am trying to display the start date of the previous quarter in a text box using the following expression:

=DATEADD(qq, DATEDIFF(qq,0,getdate())-1, 0), 100).

However, I get an error.

When I use this expression in a SQL server query, it returns the right date. Can you tell me why the expression is not working in a report?

 

[LNBruno]

You might try posting in the SSRS forum to get quicker/better responses:

http://www.tek-tips.com/threadminder.cfm?pid=1462

< M!ke >
[small]I can say nothing, which is cowardly, I can lie, which is immoral, or I can tell the truth, which will upset people. - Tiki Barber[/small]

 

[philhege]

See if the current date is available in the Globals collection. Use that instead of getdate() in your function.