Business Object desktop intelligence formula

[boboleft]

I am using Business Object desktop intelligence and trying to come up with a formula to count days in between two dates. I have two date fields say start date and end date.I need to find out the days between these two dates excluding Weekends(saturday and sunday's).

Any help would be appreciated.

Thank you again

 

[fisheromacse]

I think this FAQ may have the answer for you:

http://www.tek-tips.com/faqs.cfm?pid=149&fid=243

Direct link to Ken's wonderfully helpful page:

http://www.kenhamady.com/form01.shtml

 

[hilfy]

Also, this forum is specifically for Crystal Reports. You'll probably get a better response for DeskI reports In the Business Objects solutions forum here:

http://www.tek-tips.com/threadminder.cfm?pid=393

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.