calculate future date

[qster]

Hello,

I am trying to create a form in Access to calculate future dates.
What I am trying to accomplish is setting a due date.
i.e. 30 days, 60 days and 90 days.

This works fine with the simple formula, however I would like to add some special conditions.
For example:

1. I've figured how to set it so that if the due date returns a weekend, it will search out the next weekday.

2. I want to add in Holidays (some static and some occur every 2nd monday of a month)

3. I would like to be able to exclude 2 months during the year on which the dateAdd function does not give these 2 months as a due date.

Thank you in advance.

 

[PHV]

Create your own function in VBA.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MichaelRed]

search the FAQs. The function is found with some explination of how to.



MichaelRed

 

[randy700]

I'm confused. This is the fourth time you've posted this question. You've been provided with loads of suggestions and, in one case, you responded by giving 3 people stars. You have NOT reported results of any of the other advice provided. Has none of this advice been helpful?


Randy

 

[CautionMP]

qster,
I agree with randy700! Between the FAQ's and the following posts, what's not working for you?
22 Aug 06 Microsoft: Access Forms: Dateserial help with future dates excluding a date range
23 Aug 06 Microsoft: Access Other topics Forum: Date must end on a weekday
25 Aug 06 Microsoft: Access Modules (VBA Coding) Forum: Future Date calcuation excluding dates