Scenario:
I want to subtract 7 days from the date I choose in the date parameter
Solution:
In the expression write=Dateadd("d",-7,Parameters!RefDate.Value)
Scenario:
I want just change the year part of the Date field. Changing 365 days does not work because of the leap year.
Solution:
SQL Command:
UPDATE dbo.TableToUpdate
SET [Date Column] = DATEADD(YEAR, -2, [Date Column]);
SSRS Command:
No comments:
Post a Comment