I know I can use the DATEADD function to take a date in TSQL and add a YEAR or subtract it. However how can I keep the weekday shifting.
For instance I can take 1/10/2018 and subtract a year to make it 1/10/2017 or add a year 1/10/2019. However all three of those days represent different weekdays.
What is the easiest method to see the same weekday a year in the future or a year in the past?
So extending the example above I would take 1/10/2018 and adding a year would return 1/9/2019 and subtracting a year would return 1/11/2017.