SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table tb(InvoiceNo int, InvoiceDate Date, CustomerName varchar(10));
insert into tb values(3,'2021-08-06','B');
1 rows affected

CREATE OR ALTER TRIGGER IgnoreInvoices ON dbo.tb
    INSTEAD OF INSERT
 AS
    BEGIN
    SET NOCOUNT ON;
    INSERT dbo.tb(InvoiceNo, InvoiceDate,CustomerName)
        SELECT InvoiceNo, InvoiceDate,CustomerName
        FROM inserted
        WHERE InvoiceDate >= '2022-01-01';
    END

CREATE OR ALTER TRIGGER IgnoreInvoicesupdate ON dbo.tb
    INSTEAD OF UPDATE
 AS
    BEGIN
    SET NOCOUNT ON;
  IF EXISTS 
  (
     SELECT 1 FROM inserted i
       JOIN deleted AS d ON i.InvoiceNo = d.InvoiceNo
       WHERE d.InvoiceDate >= '2022-01-01' AND i.InvoiceDate >= '2022-01-01'  
  )
  BEGIN
     UPDATE src 
       SET CustomerName = i.CustomerName, 
          InvoiceDate = i.InvoiceDate
       FROM dbo.tb AS src
       INNER JOIN inserted AS i
       ON i.InvoiceNo = src.InvoiceNo
       AND (src.InvoiceDate <> i.InvoiceDate or src.CustomerName = i.CustomerName);
  END
    END
insert into tb values(4,'2022-05-02','A');
insert into tb values(2,'2021-08-06','B');
2 rows affected

select * from tb


InvoiceNo
InvoiceDate
CustomerName


3
2021-08-06
B

4
2022-05-02
A


UPDATE tb SET InvoiceDate = '2021-05-02' WHERE InvoiceNo = 4;;
UPDATE tb SET InvoiceDate = '2022-05-02' WHERE InvoiceNo = 3;;
2 rows affected

select * from tb


InvoiceNo
InvoiceDate
CustomerName


3
2021-08-06
B

4
2022-05-02
A


Delete from TB
2 rows affected

insert into tb values(1,'2021-08-06','B');
insert into tb values(2,'2022-05-02','A');---This record is correct but still it won't insert
2 rows affected

select * from tb


InvoiceNo
InvoiceDate
CustomerName


2
2022-05-02
A