Delete from schema.table_name
Where start_date >= date'20211102' ;
Update schema.table_name
Set end_date = date'2999-12-31'
Where end_date >= date'20211102' ;
Delete from schema.table_name
Where start_date >= date'20211102' ;
Update schema.table_name
Set end_date = date'2999-12-31'
Where end_date >= date'20211102' ;