Update Date Field
I have a database that that has a renewal date that has to be updated every time a renewal is entered renewals are every two years at the end of the month, how do I make the date automatically add a year on its own. Currently I'm using repeating values like Renewal one Renewal two with this formula
=DateSerial(Year([LicenseExpireDate])+6,Month([LicenseExpireDate]),Day([LicenseExpireDate]))
|