Good morning and thanks for any suggestions!
Using VBA: How to use the control AUTO POLICIES.EFFECTIVE DATE to set 6 months ahead in
the control EXPIRATION DATE. Both use Short Date as the format type.
In the EXPIRATION DATE field I tried =[EFFECTIVE DATE]+182 but in some instances it jumps a day ahead or behind.
For example, if I input 01/25/2022 the result is 07/26/2023 instead of 07-25-2022
Using a command button to enter in date is my preferred end result. That way I’ll have a button for a
6-month policy and a 12-month policy