Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: date formula Post Reply Post New Topic
Author Message
joekanant@gmail
Newbie
Newbie
Avatar

Joined: 07 Nov 2018
Online Status: Offline
Posts: 8
Quote joekanant@gmail Replybullet Topic: date formula
    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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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).
IP IP Logged
joekanant@gmail
Newbie
Newbie
Avatar

Joined: 07 Nov 2018
Online Status: Offline
Posts: 8
Quote joekanant@gmail Replybullet Posted: 11 Dec 2019 at 5:23pm
can u send me the web link?

thx
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 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

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.