K3 ERP warehouse receiving and picking document date Control

-- If exists (select * From DBO. sysobjects where id = object_id (n' [DBO]. [icstockbill_insert] ') and objectproperty (ID, n' istrigger') = 1) -- drop trigger [icstockbill_insert] -- go /******************************* **************************************** * ******* Table Name: icstockbill ** trigger name: icstockbill_insert ** created by: wucy ** creation date: 2011/07/11 ** Description: prevents incorrect input/output of document dates for many years, such as 2 2111-07-01 error-07-01, ** resulting in a long time of sending and receiving report settlement being negative ***************************** **************************************** * ********/create trigger [DBO]. [icstockbill_insert] on [DBO]. [icstockbill] For insert, updateas declare @ fdate datetimedeclare @ day_no int select @ fdate =. fdate from icstockbill a inner join inserted B on. finterid = B. finterid select @ day_no = datediff (month, (select convert (varchar (10), get Date (), 120), @ fdate) If @ day_no> 2 begin rollback Tran raiserror ('the ticket creation date cannot exceed the last month! ', 18, 18) End