Does any one have any pointers on the best way to find the number of working days betwwen two dates based on the base calendar. Any help appreciated.
Well… if you’re talking about not using any holiday in the calculation, an easy way for me seems to get the total number of days in that period, then getting all the sundays on that period and make the difference… Using the table Date will help you A LOT on that task… In fact… you can set a filter…and using count…(no more clues…) 
If you have access to Designer & Form 7604, check code on OnAfterGetRecord wherein its finding out the Non-working days. Its not exactly what you are looking for, but may help.
Thanks, The check for non-working day in form 7604 was actually what I was looking for. I just needed to put it into a loop to check every day in the range. I nedded to take holidays into account to could not just use the date table.
If your client is willing to pay for a few more tables and forms you might want to set up a system where they can flag days as “working” or “non-working.” The number of nonworking days varies tremendously from company to company, even within one country. And some companies observe certain holidays while others do not, etc., etc. The main table would just have the date with a working/non-working day flag (and perhaps a comment table and some other fields.)
quote:
Originally posted by horrigan
If your client is willing to pay for a few more tables and forms you might want to set up a system where they can flag days as “working” or “non-working.” The number of nonworking days varies tremendously from company to company, even within one country. And some companies observe certain holidays while others do not, etc., etc. The main table would just have the date with a working/non-working day flag (and perhaps a comment table and some other fields.)
In fact you just need to keep the “non-working” days in the table, as all other days will be working ones (and the number of non-working days, excepting on Santa Claus and politicians is usually a lot lower than the one of working days). Regards,