URGENT: Count # of business days elapsed

[kridg]

The database stores the date as a string ("19910731&quot, and (thanks Malcolm!) I was able to convert the string to a date value.

Now I need to count the number of days that have elapsed since the case was opened, but have to exclude Saturday and Sunday.

If the CurrentDate is 8/21/2000 and the FileDate is 8/1/2000 the correct answer (excluding Sat & Sun) would be 15. I get 21.

Thanks for any help!

 

[MalcolmW]

This formula needs V8 to work, so I hope you have it.
DateVar EachDate := {FileDate};
NumberVar BusDays ;
While EachDate <= CurrentDate
Do
(If DayOfWeek(EachDate) < 6 then
BusDays := BusDays + 1 ;
EachDate := EachDate + 1
);
BusDays;

This may need some tweaking, depending on how you count business days. Ie, if the date range is from Monday to Tuesday in one week, is that one or two days?