I am wondering if it is possible to concatenate a parameter in the cmd.Parameters.AddWithValue.
In this case the update_table would be written '08-01-2020
I am updating the DB to a new date 1 year in the future which will be used to check against and then kick a reminder up that the date is approaching. That part of the code works fine. I'm not sure how to concatenate, properly, the value to be written.
DECLARE @reportYear int = YEAR(getdate()) + 1
UPDATE Last_Update_table SET FHU = @fhu") cmd.Parameters.AddWithValue("@fhu", SqlDbType.DateTime), value = "08-01-" + "@reportYear" cmd.Connection = con con.Open() cmd.ExecuteNonQuery()