Skip to Content
0
Former Member
Dec 02, 2008 at 07:02 PM

Add number of business days to date field

321 Views

Hello, I noticed that there is not much discussion in the forum surrounding u201Cbusiness daysu201D so I hope this post/discussion/solution contributes to the content of this forum.

I am using the following 3 formulas to try to Add number of business days (based upon a table field) to a specified date:

1. Variable name = SetVar

//Set Variable for Add Business Days:

DateVar Array Holidays;

DateVar Target:= CDate({TMS_MOVEMENT_EVT.EVT_DATE}); // Put your field name in here

NumberVar Add:= {DTCI_DOD_TRANS.TRANS}; // put the number of days here to add (a positive number)

NumberVar Added := (0);

2. Variable name = AddBizDays

//Adding Business Days:

EvaluateAfter({@SetVar});

WHILE Added < Add

Do (target := target +1;

if dayofweek (target) in 2 to 6 and not (target in holidays)

then Added:=Added+1

else Added:=Added);

Target

3. Variable name = HOLIDAYS

//Holiday Array Formula for the report Header:

BeforeReadingRecords;

DateVar Array Holidays := [

Date (2003,12,25), // you can put in as many lines for holidays as you want.

Date (2003,12,31)

];

0

I am successfully getting my data needed to make the necessary calculations and variable assignmentsu2026 I believe that my ISSUE is that I am not sure where to place these formulas into my report so they assign the variables and execute properly when previewing my report. I am curious if that is my issue, and if so, can someone provide me direction on where to put each of these formulas in my report.

Currently, when I try to preview the report, I get the following Crystal Reports Error: -u201CA number, currency amount, Boolean, date, time, date-time, or string is expected here.u201D

Then Crystal automatically opens the AddBizDays formula and highlights the word added, see below RE: u201CWHILE Addedu201D

For reference, my report has 3 groups, and I am displaying all of my output information (and locating my formulas) in the group footer #3 report section. I have moved them around to other report sections/groups/placements, but to no success.

Thanks so much.

Best, Matt