The Signed by date is typically the Census Date for the session. Both the student and instructor need to have signed the form before the deadline.
The Approval by date only applies to Contracts and not Designation forms. By this deadline, the instructor must sign off that the work was done satisfactorily as stipulated by the contract.