CREATE OR REPLACE TRIGGER FORM.AFTER_INSERT
  AFTER INSERT
  ON SCHEMA.TABLE
  REFERENCING 
    NEW AS new_
  FOR EACH ROW
  BEGIN ATOMIC
    DECLARE OLD_START_DATE DATE;
    DECLARE OLD_END_DATE DATE;
    
    SET OLD_START_DATE = (select coalesce(max(t.start_date), date('01.01.2999')) FROM SCHEMA.TABLE t where t.id = new_.id and t.START_DATE<>new_.start_date);
    SET OLD_END_DATE = (select coalesce(end_date,date('01.01.2999')) FROM SCHEMA.TABLE t where t.id = new_.id and t.START_DATE = OLD_START_DATE); 
    IF (new_.START_DATE < OLD_START_DATE) and (OLD_END_DATE = date('01.01.2999')) THEN
      
      UPDATE SCHEMA.TABLE t SET t.END_DATE = date(date(OLD_START_DATE)- 1  day)
        WHERE t.ID = new_.id and t.START_DATE = new_.start_date; 
    
    
    END IF;
  END;