The date must be after today's date. The reason for this is to accommodate an existing, active agreement, if one is in effect.
The active agreement, if one exists, expires on the effective date of the new one since only one agreement can be in effect at a time.