Removes Holidays from Date Diff Cal.

[Nittylions]

I currenly have a module set up to exclude weekends from 2 different dates. I now need to expand that to also exclude certain holidays and have no idea how to do it. It will normal be the same holidays every year. Any help would be great.

 

[HiTechCoach]

I use a holidays table to store these dates.

Here is a great code example:

fNetWorkdays and fAddWorkDays

Hope this helps ...

 

[Nittylions]

I use a holidays table to store these dates.

Here is a great code example:

fNetWorkdays and fAddWorkDays

Hope this helps ...

So all I'll need to do is add the table for holidays and then copy in this code over my current code?

 

[HiTechCoach]

So all I'll need to do is add the table for holidays and then copy in this code over my current code?

Make a backup! Make a back up!

Yes you will need to create the table and populate it with the dates.

Make a backup! Make a back up!

I would test on a copy of your database. I would place the code in a new module to test it. No need to delete you current code.

TIP: Immediately after pasting any code, I always manually compile the code before doing anything else.

Don't forget to make a backup!

 

[Nittylions]

Make a backup! Make a back up!

Yes you will need to create the table and populate it with the dates.

Make a backup! Make a back up!

I would test on a copy of your database. I would place the code in a new module to test it. No need to delete you current code.

TIP: Immediately after pasting any code, I always manually compile the code before doing anything else.

Don't forget to make a backup!

I always make a back up when getting help from outside my mind. I'll ley you know how this goes.