date formula
Printed From: Crystal Reports Book — Forum Name: Technical Questions
Posted By: joekanant@gmail — 10 Dec 2019 at 5:29pm
Hi,
I need to count working days. which are those working days is not counting the holiday days. for example 1 week there are 7 days but because there is sunday the result will be only 6 days. And if there were another holidays so the result will be reduced by the another holidays and the result can be less than 6.
Does anyone can help?
thx,
Joe
Posted By: DBlank — 11 Dec 2019 at 2:23am
Best case scenario is to have a calendar table with your dates in it and exclude the values identified as holidays.
If that is not possible you can put a really lengthy formula that identifies each holiday and a subtraction process if that holiday falls in your select criteria.
Posted By: kevlray — 11 Dec 2019 at 3:58am
Also Ken Hamady (check his website) created a formula that handles most regular holidays. I even modified it for our special holiday schedule at our organization (we always get the day after Thanksgiving off and Christmas Eve, unless a holiday falls on a Sunday).
Posted By: joekanant@gmail — 11 Dec 2019 at 5:23pm
can u send me the web link?
thx
Posted By: kevlray — 12 Dec 2019 at 4:28am
It may take a bit of searching to find where the formula is. You could also e-mail him.
ken@kenhamady.com
|
