I am creating a Customer Followup database that generates future contact dates for salespersons based on a single Start Date. From the Start Date, we calculate 21 days, 3 months, 6 months, 12 months, 18 months, 24 months, etc. to get the future contact dates. How do I ensure that the calculated future dates do not fall on a Saturday or Sunday (when the salespersons are not in the office)?

Sample: Date NP Start + 180

quote:

---

Originally posted by richpayne:

I am creating a Customer Followup database that generates future contact dates for salespersons based on a single Start Date. From the Start Date, we calculate 21 days, 3 months, 6 months, 12 months, 18 months, 24 months, etc. to get the future contact dates. How do I ensure that the calculated future dates do not fall on a Saturday or Sunday (when the salespersons are not in the office)?

Sample: Date NP Start + 180

---

There is a way to eliminate the weekends from the calc. I am not familiar with it though. I am pretty sure you can find an example of it on John Mark's site at http://www.databasepros.com

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

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

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

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

A simple way is to use:

Corrected Future Date(date) =

Case(

Day(Future Date) = 1, Future Date + 1,

Day(Future Date) = 7, Future Date - 1,

Future Date

)

-bd

[This message has been edited by LiveOak (edited September 20, 2000).]