Thank you Hugo . I have sent an email to the business user asking for how to handle that particular record.

I will check the code and get back.

Hi Hugo ,

Thank you for the quick reply. I checked the code ...the TOCORRECTDATE is all 11/30/2015. I am looking only for specific dates that need to change. How do...

Hi Hugo,

Below is the create table and values inserted.

create table membercontact

(memberid int,

addresstype varchar(20),

status varchar(20),

fromdate date,

todate date,

adddate date,

addinit varchar(20),

changedate date,

changeinit varchar(20))

insert into membercontact values

(100001 , 'residence','valid','2015/12/01','2100/12/31','2015/12/01','deamon','2016/03/10',''deamon')

(100001 , 'residence','valid','2016/01/01','2100/12/31','2015/12/01','deamon','2016/03/10',''deamon')

second scenario

insert into membercontact...