The conversion of a date data type to a datetime data type resulted in an out-of-range value
Solution 1:
It worked like this for me
ALTER TABLE NAME_TABLE ALTER COLUMN NAME_COLUMN datetime2 not null
It worked like this for me
ALTER TABLE NAME_TABLE ALTER COLUMN NAME_COLUMN datetime2 not null