Auto populate the planned start date on change table

[pavan3]

Hi All,

I need to auto populate the planned state date value, as soon as the change leaves the new state, unless the next state is Review, Closed or Cancelled. 

The planned start should be after the current date & time + the mimum lead time(duration field).

Can you please help on the above requirement.

[newhand]

@pavan3 
How about business rules。

trigger：before update    
condition: status changes from  new
               and  status is not one of   Review Closed  Cancelled

               and planned start date is empty

and on the script tab, wire some scripts to set the planned start date .

such as  :  current.pland_start_date = xxxxxxxx