Dateadd Update Works But Adds 2 Or 3 Yrs-not 1

I have a page that is supposed to add a year to a record when it loads. The problem is that it adds 2 or three years instead.


Here is the page_load event:Sub page_load(sender as object, e as eventargs)


Try


Dim connection As SqlConnection = new SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))


Dim command As SqlCommand = new SqlCommand("Updateexpiredate", connection)


command.CommandType = CommandType.StoredProcedure





Dim param0 As SqlParameter = new SqlParameter("@memberid",SqlDbType.Int)


param0.Direction = ParameterDirection.Input


param0.Value = memberid


command.Parameters.Add(param0)





connection.Open()


command.ExecuteNonQuery()


connection.Close()


myerror.Text = "Thank You! Your account was updated"


Catch ex As Exception


myerror.Text = ex.Message


End Try


End SubAnd here is the SPROC:CREATE PROCEDURE Updateexpiredate


(


@memberid int


)


AS


UPDATE


members


SET


expiredate=(dateadd(year,1,expiredate)) <--I also tried expiredate=(dateadd(month,12,expiredate)) with the same results


WHERE


memberID = @memberID


GO