Here is the scenario:

Object has two fields:  Date Joined and Date Hours Due

When a member joins, they have one year to complete volunteer hours.  So, when a value is entered in Date Joined, I would like Date Hours Due to be populated with a date value that is one year later than Date Joined.

Now, here is the catch.  Sometimes, members get extensions.  If this is the case, the Date Hours Due would be updated with a new value.  So, I do not want the trigger to set it to one year after Date Joined to fire, if Date Hours Due is already populated.

Make sense?

Thanks you in advance for the help!

--Rod