NEED AGING FORMULA THAT DOES NOT COUNT THE WEEKENDS

[Nmartin95]

How can I get an aging formula which does not take into consideration the weekend? So it would be how ever long a work order was open not counting the weekends into the age. The formula would give it to me the age in days.
Any help would be greatly appreciated thanks. I am using crystal reports 7.01.

 

[synapsevampire]

The only way that comes to mind is to loop through the dates from min to max and count them for

dayofweek({Table.Datefield}) < 6.

Someone must have a better means of doing this...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[mbarron]

Crystal 7 doesn't allow for loops. Here is a link to Ken Hamady's site. It contains the formula that your looking for.

http://www.kenhamady.com/formula.html

Mike