Okay, this is what I came up with, it is pretty close to what I want:

CREATE TRIGGER orderclose ON dbo.WorkOrders

FOR INSERT, UPDATE

AS

IF UPDATE(OrderStatus)

BEGIN

UPDATE c SET DateCompleted = getdate()

FROM inserted i

INNER...