View Single Post
  #1 (permalink)  
Old September 13th, 2005, 07:40 PM
desireemm desireemm is offline
Authorized User
 
Join Date: Aug 2004
Location: LAKESIDE, California, USA.
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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]))

Reply With Quote