>What is the best way to handle adding months to a date. My user would like me to establish a from date and a to date on a form. The from date is pretty straight forward and will always be the first day of the month (e.g 12/01/1999 or /05/01/1999). Now the tricky part is that they want me to calcualte the to date based on a variable called lead time. The lead time contains the number of months of lead time. So what is the best way to figure out the to date when we have a from date of say 12/01/1999 and the lead time is 17 months. Any help would be appreciated.

Bret,

Is there some problem with using GOMONTH()?