Hi,

Is there any function in baan that can calculate no of days excluding sundays and holidays?

I need this in report that will display production lead time based on start date and completion date.

Thanks.

You could use the company calendar stored in table tirou400 to count the number of records between the given dates and at the same time excluding those records which are defined as weekends or holidays. The field "Day Type" represents the type of day (Regular/Weekend/Holiday)

Thanks,
NS

Thanks NS.:D