>>>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()?
>
>Well George you have just pointed out again that I cant remember all the functions. Once I read you reply, the DUH light came on over my head. Man I am getting too old to remember all the functions. And unfortunately the area I was looking for in the VFP help never referenced the GOMONTH as a see also.
>
>Thanks again...
Hi, Bret.
In File Section & knowledge Base, there are more samples on date calculation.
such as calculate the age of a person,
the difference on 2 dates on year, month, days
(e.g. {01/01/1999} to {03/04/2000} is 1 year, 2 months, 3 days...)
txtdate, cdatetime textbox d/l for handling such field with easy...
^_~
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.