Is the number of hours important, or can you say "2 weekdays"?

The DateAdd function allows you to add (or subtract) weekdays, which ignore weekends.  Unfortunately, the DateDiff function does not do the same.  But, a little manipulation of the formula should give you what you need.  Something like:

If DateAdd("w",-2,{MyShipDate}) < {MyOrderDate} Then
flag it late
Else
don't flag it late




Edited by Lugh - 04 Dec 2007 at 10:35am

This is interesting. The "w" option of DateAdd() doesn't work on my computer. It includes weekends as well. I wonder if this has always been a bug or is new? Anyway, I re-worked the problem using the DayOfWeek() function to determine if a weekend is within the range. I'm assuming that no products get ordered on a Sat or Sun? If so, this should work for you.

if {@Proof Out} > iif (DayOfWeek({Job.Date-Entered},2) >3, DateAdd("d", 4, {Job.Date-Entered}), DateAdd("d", 2, {Job.Date-Entered})) Then "Late"

If you need a great reference guide for all the date formulas in Crystal Reports, check out Chapter 6 of my book Crystal Reports Encyclopedia

Edited by BrianBischof - 08 Dec 2007 at 2:07pm

Yeah, it's a bunch of code all in one big chunk.
I personally like to write very consise code, but this does make it tough to see all the details.
I'll rewrite it here so that you can see the individual steps.

NumberVar DayEntered;
DateTimevar LastValidDate;

//Get which day of the week the job was entered.
//This formula returns 1 for Monday and 7 for Sunday
DayEntered := DayOfWeek({Job.Date-Entered},2);

//If this is Mon-Wed, then just add two days
if DayEntered <= 3 Then
   LastValidDate := DateAdd("d", 2, {Job.Date-Entered});

//If this is a Thursday or Friday, then we need
// to add two extra days to bump it over the weekend.
if DayEntered >= 4 Then
   LastValidDate := DateAdd("d", 4, {Job.Date-Entered});

//Now that we know what the last valid date is,
//see if the proof date comes after it.
if {@Proof Out} > LastValidDate Then "Late"

Once you understand this code, you can look at the original formula and see if it makes more sense now.
I cover all the Crystal Report date related functions on pages 255-261 in my book Crystal Reports Encyclopedia