Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Work days between two dates Post Reply Post New Topic
Author Message
crmetal1
Newbie
Newbie


Joined: 30 Oct 2012
Online Status: Offline
Posts: 5
Quote crmetal1 Replybullet Topic: Work days between two dates
    Posted: 30 Oct 2012 at 10:16am
I am using the DateDiff function but I would like to have it calculate only work days between two dates.
Any ideas??


Edited by crmetal1 - 08 Nov 2012 at 10:56am
IP IP Logged
crmetal1
Newbie
Newbie


Joined: 30 Oct 2012
Online Status: Offline
Posts: 5
Quote crmetal1 Replybullet Posted: 08 Nov 2012 at 10:56am
I revised my question.
Any ideas??
IP IP Logged
aharonmc
Newbie
Newbie


Joined: 02 Apr 2012
Location: United States
Online Status: Offline
Posts: 10
Quote aharonmc Replybullet Posted: 12 Nov 2012 at 7:48am
Lots of good info on that at these two adresses:
http://tek-tips.com/faqs.cfm?fid=4465
 
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 13 Nov 2012 at 10:54pm
HI
 
If you want to exclude only Saturday and Sunday then use below formula :
 
 

Local DateTimeVar d1 := {Orders.Order Date};

 Local DateTimeVar d2 := {Orders.Ship Date};
 
DateDiff ("d", d1, d2) - (DateDiff ("ww", d1, d2, crSaturday) - DateDiff ("ww", d1, d2, crSunday))
Thanks,
Sastry
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.033 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.