Hello Experts Exchange
I am working in SSRS and I want to get the date for the same day last year based on the week number, so for example 27/06/2015 I want to get the same day of the week for last year which would be 28/06/2014.
I have the code that give me the week number.
I have the code that give me the day number.
=DatePart(DateInterval.Weekday, Parameters!SalesDate.Value, FirstDayOfWeek.Sunday)
What I need now is to bring these together to give me last years date, doe anyone know the code I need to make this work?