How to calculate the next quarter excluding weekends and holidays

[Madagaluna]

Hi,

This is my second day on the board and my first post. I'm relatively new to ACCESS. I am building a database for work which will take an entered date from a table ( [ss_WIRB_IRB_2_Approval]![Date2Approved] ) and calculate the next quarter based on the current date. The next quarter cannot fall on a weekend or holiday. I'm primarily using the wizard, although I know a little SQL.

Any help would be greatly appreciated.

Thanks!

 

[HiTechCoach]

The only way I know to handle this is with VBA code. Would you like to see a VBA solution?

 

[Madagaluna]

absolutely. Any information is welcome. Thanks so much!

 

[HiTechCoach]

Great. I know we can do it with VBA.

When writing code you have to be very specific in what you want t6he computer to do. It will only do exactly what you tell it.

I need to you clear up what you mean by this:

will take an entered date from a table ( [ss_WIRB_IRB_2_Approval]![Date2Approved] ) and calculate the next quarter based on the current date.

How you do calculate the next date?

What do you mean by next quarter?
- if today is 3/25/2010, then the first day of the next quarter would be 4/1/2011

- Is that adding 3 months? (3/25/2010 + 3 months is 6/25/2011)

- Is that adding 90 days? (3/25/2011 + 90 days is 6/23/2011)

 

[HiTechCoach]

Also, when the date falls on a weekend or holiday how do you want to adjust the date? Forward or Backwards?

 

[Madagaluna]

by next quarter I mean 3 months
Push the date forward

Thanks so much for your help.

 

[HiTechCoach]

I use this code:

fNetWorkdays and fAddWorkDays (Click Here)