Audit Trail trigger can't detect if dates are the same
I believe you just have to drop the WHERE clause from this SELECT:

SELECT @insertedDate = i.DueDate, @deletedDate = d.DueDate
    FROM inserted i, deleted d WHERE d.DueDate &lt;&gt; i.DueDate