Hi everyone I was wondering if anyone can see if anything is wrong with this code,=DateSerial(Year([FIRSTRENEWALDATE])+2,Month([FIRSTRENEWALDATE]),Day([FIRSTRENEWALDATE]))
I use it to help me keep track of when employees need renewals done. What it does in each field is add two years which is based off the first renewal date this all comes from when their final suit was done. There is a total for five fields that all have this code so if the first renewal date is 04/28/2004 then the first renewal will say 4/31/2006 and the second will say 4/31/2008 so on and so forth, this is the way the department wants it done and how they want the reports to look. Does that make sense??
I use it to help me keep track of when employees need renewals done. What it does in each field is add two years which is based off the first renewal date this all comes from when their final suit was done. There is a total for five fields that all have this code so if the first renewal date is 04/28/2004 then the first renewal will say 4/31/2006 and the second will say 4/31/2008 so on and so forth, this is the way the department wants it done and how they want the reports to look. Does that make sense??
