Working Days Function

[Commandolomo]

Does anyone know if there is a formula or function within Business Objects 6.1 that when you run a report that returns sets of two different dates, it returns the number of working days between them, and not the number Calandar days? A bit like the NETWORKDAYS function in MS Excel - and I do not want to have to export my info to Excel!!

Any ideas?

Regards

 

[bdreed35]

Try this formu, forum393 if you don't get a response here. This is almost all Crystal Reports here.

~Brian

 

[synapsevampire]

In Crystal and many other languages the function is:

datediff("d",{table.date1},{table.date2})

As Brian pointed out, this is a Crystal forum, not BO.

-k

 

[Commandolomo]

Many thanks for your help