I have some reports. I need to set default values for parameters -2 last weeks I have query "=DatePart("ww", Fields!DataZgoszenia.Value)" and I don't know how to substract 2 last week Some ideas?

Hi There Please try this one =DateAdd("d",-14,today()) Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

DATEADD(WEEK, -2, #8/18/2011#)Best Regards,Uri Dimant SQL Server MVP http://www.dfarber.com/microsoft-solutions/mssql-server.aspx http://www.dfarber.com/computer-consulting-blog.aspx http://sqlblog.com/blogs/uri_dimant/

Hi URi I think it might be like this in SSRS =DateAdd("ww",-2,today()) Many thanks Syed