>>>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.
>>
>>I guess the first question is what do they mean by "month". Is it 30 days, or 4 weeks or the actual calendar month?
>
>The lead time will always be a number to represents months. So if the value in lead time is 13 they wish 13 months added to the from date to get the to date.

Sorry Bret. An example to explain my question. If they ask to make the end date one month from July 1. Should the answer be?

August 1 (1 calendar month)
July 31 (30 days)
July 29 (4 weeks)