adding a duration to a date

[stephbaillie]

Hi

I'm looking for a way to add a duration (3 or 6 months) to a date. How can I do that?

[Kurt Knippel]

quote:

---

Originally posted by stephbaillie:

Hi

I'm looking for a way to add a duration (3 or 6 months) to a date. How can I do that?

---

Many different ways, here are 2 of them:

EndingDate = StartingDate + 90

EndingDate = Date (Month (StartingDate) + 3, Day (StartingDat), Year (StartingDate) )

Both of these add 3 months to the StartingDate.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=