I am trying to create a date like so
expirdate=dateadd(YEAR, 8, d.taxyear)
This should make this expire date be 8 years from the tax year.
This tax year column is a varchar....
I am still getting error when I try and convert the tax year to a date or whatever it needs to be to make this work.
In the end the expire date should be 8 more years from the year value in the taxyear.
This is the error
Conversion failed when converting date and/or time from character string.