SQLTeam.com | Weblogs | Forums

SQL reporting services @date -1

sql2008r2

#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 ?


#2

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.


#3

Thanks alot

=DateAdd("d",-1,@Date)