SQL reporting services @date -1

SSAS and SSRS
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.

1 Like
3

Thanks alot

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