SQLTeam.com | Weblogs | Forums

SQL reporting services @date -1



Hi Experts
I am trying to create a report in report builder , the query works fine on @date . I have some fields to show the previous date data .
Can it handle in expression ?


Not clear from what you have posted how you are using @Date parameter, if you are using it. If you want to get the date for the day previous to @Date, you can use the DATEADD function that SSRS has.


Thanks alot