Skip to Content

business hours excluding holidays

Nov 16, 2017 at 10:01 AM


avatar image


Could someone please guide me with the logic of excluding holidays from business working hours?

I have a requirement where I have to calculate the time spent between two dates excluding the weekend and the holidays. I have managed to remove the weekends but need a work around for removing the holiday time.

Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Nov 16, 2017 at 10:35 AM

You have to maintain calendar table in the data base with some holidays flag and then use this table in the universe and report to exclude holidays.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Thankyou for the response.

We do have a calendar table having only holiday dates depending upon holidays at various group.(for eg - India country).

How do I link only holiday dates with the dates where in I need to use this calculation?


do you have some flag which indicate the holiday dates? if yes then you can add query filter to exclude holidays based on the flag.

We just have a holiday object giving dates when it is an off for what reason in which group.

Can you suggest how do implement holiday logic?

vadc8.png (8.2 kB)