Print Page | Close Window

date formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22846
Printed Date: 28 Apr 2024 at 7:46am


Topic: date formula
Posted By: joekanant@gmail
Subject: date formula
Date Posted: 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


Replies:
Posted By: DBlank
Date Posted: 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
Date Posted: 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
Date Posted: 11 Dec 2019 at 5:23pm
can u send me the web link?

thx

Posted By: kevlray
Date Posted: 12 Dec 2019 at 4:28am
http://www.kenhamady.com/ - http://www.kenhamady.com
It may take a bit of searching to find where the formula is.  You could also e-mail him.

ken@kenhamady.com


Print Page | Close Window