I am not sure if I understood your question in a right way, but if what I understood was true the query below will compare ProfileId of two tables and update the endDate fild with current date:
UPDATE CustomerProfile as c
SET endDate = GETDATE()
WHERE not exist (select 1 from NewData as N where N.ProfileId= c.ProfileId );