Hi all.
We want our contracts to expire on the last day of our fiscal year, June 30, three years in the future. For instance, if a contract is executed on Dec. 16, 2025 it would expire June 30, 2028. It the contract were executed on Jan. 2, 2026, it would expire June 30, 2029. If there is no way to create a formula for this, I'm fine with adjusting the form or document once per calendar year. I can't figure out how to set a fixed expiration date, or to offer that entry as a field. We want to preserve the functionality of having notice of pending expiration as part of the Lifecycle preset functionality.
Anyone have experience with this or advice?