iam making trigger insert query
CREATE TRIGGER trg_insertZYP_NEW
ON ZYP
AFTER INSERT
AS
BEGIN
INSERT INTO ZYP (zy_id)
VALUES (NEW.zy_id);
END ;

I have a trigger set on my table and it works with INSERT INTO but when I add the date using procedure,it does not fire and is letting the bad date to be written into the DB.