Difference calculation

[njain76]

I am printing our a report absed on two input parameters.
1) Start Date
2) ENd Date

Both these parameters are fields in table A.

I want to calculate the day difference between start date and end date based on whether they are working days or not. There is another table B which stores whether a particular calendar date is a working day or not. It has a record for each calendar day and each record has a field called daytype. If daytype = "WRK" then it is a working day.

Please help.

Thanks

 

[Madawc]

For Crystal 8.5, read the table between start date and end date. Have a running total that tests daytype = "WRK" before counting.

You might need to put this function as a subreport. This would display the value, and could also return it using a shared variable.

Madawc Williams
East Anglia, Great Britain