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]))

I would use the DateAdd() function. You can use this to add 1 or 2 years to a date.



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com