Difference between execution date and effective date
Execution date: The date of signing the contract between the parties. It does not mean that the contract becomes immediately effective, although it often happens.
Effective date: The date when the contract becomes "live" and operative.