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.

I am building Stored procedures thus why it looks like I'm asking a lot of question. Apologize for that.

The STATIC value needs to be exactly that. Each year on 08-01-yyyy I need to be reminded to file Federal paperwork. Once the paperwork s filed then I check it off as complete and I want to write the next year's "reminder date" so it is not overlooked again.