Hi,
If you want to track shipdate changes when your order is acknowledged and open, you may consider using update trigger. Place the following code into your update trigger, it will insert a record of the original shipdate only when the order status…