Sql Server Error: Unable to modify table.   The conversion of a date data type to a datetime data type resulted in an out-of-range value. The statement has been terminated

Sql Server Error: Unable to modify table.   The conversion of a date data type to a datetime data type resulted in an out-of-range value. The statement has been terminated

Question
How do you resolve the"'YourTableName' table
- Unable to modify table.  
The conversion of a date data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated."

Solution
Warning! this solution should not be performed on a production Server, assuming this error happens on your local Development Machine. 
1. Recreate or create a new column that has the Data type Conversion Problems.

 This error happens when you are trying to insert into the Date Column in your database that has a "not null" specified. Do not insert the default date value that happens to be 1/1/0001 12
00
00 AM into the date column otherwise, this error happens. Make sure that the date value has the correct date before you insert or update the database.