Use Begin_Date to update End_Date field (+90days)

ColdPolarBear · December 9th, 2004, 10:18 PM

I am new to triggers and scripts.
I have a table that contains 2 fields. Begin_Date and End_Date.
The Begin_date is entered into SQL 2003 via a front end software program.

ON entry of the begin date is is possible to have a trigger fire that would automatically populate the End_Date field with the following result. End_date = Begin_Date +90 Days.

Could you recommend a procedure and possible script.

Regards,

ColdPolarBear

jemacc · December 9th, 2004, 11:17 PM

You can add this to your trigger

Code:

Update your table
set End_date=Begin_date +90

Recommendation

1. Make sure you have a where clause for the records you want to update
2. Are updating just new records or existing records
3. If this will be your default use a constraints

Jaime E. Maccou