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.

 All Forums
 Development Tools
 Reporting Services Development
 Help with Report Parameters

Author  Topic 

brooksm
Starting Member

1 Post

Posted - 2007-12-29 : 21:46:48
I'm Trying to create a report parameter that will list
Today
Last 3 Days
Last 7 Days


I figured out that If I use =Today() in the expression, that will give me all records for today's date. What I can't figure out is how to get the Last 3 Days and Last 7 Days.

Thanks in advance.

Brooks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-30 : 00:40:15
Check out the DateAdd .NET function.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -