date calculation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kimee11972 - 06 Feb 2005 11:11 GMT

I have a form in which a user specifies a start date in one field. I want an
end date to be calculated and appear in the next field. There will only ever
be 2 possible end dates: 61 days from the start date (running continuously)
or 2 years from the start date.

Any help is greatly appreciated.

Reply to this Message

Doug Robbins - 06 Feb 2005 13:11 GMT

Not sure what sort of a form your talking about or how the determination of
whether it is 61 days or 2 years is determined, but you can use the visual
basic DateAdd() function in either a macro that runs on exit from a
formfield in a protected document, on in the Exit event of a control on a
userform. Type DateAdd into the vbe and press F1 to see how to use it.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have a form in which a user specifies a start date in one field. I want
>an
[quoted text clipped - 5 lines]
>
> Any help is greatly appreciated.

Reply to this Message

Rate this thread: