I have a "PurchaseDate", "ExperationDate" and "Term" fields. The calculation I need is this. When a date is entered into "PurchaseDate" and a number of months is entered into "Term" I need the "ExperationDate" to calculate the date the contract expires.

I know I know how to do this but for some reason can't figure it out.

Thanks,

Bill

Hi:

There is probably a couple of ways to do this - but this is how I would do it:

Expiration Date=

Date(Month(PurchaseDate) + Terms, Day(PurchaseDate) , Year(PurchaseDate))

Two fields:

Term: Number Field enter in days (can be a pull down menu of standard 30, 60, 90 etc

Expiration Calculation date result =

Purchase Date + Term

Lee

Thanks guys and Kenneth your script works great! Thanks so much for the help.

Bill

Lee brings up a good point.

In and invoice system, say you have 30,60,90,120 day terms. You can make a calc to determine if an invoice is past due. Then you can find on that field.