if you want to deal with the weird case where the

trandate

doesnt match the

shippeddate

, then you can use the

Actual Ship Date

column