cancel
Showing results for 
Search instead for 
Did you mean: 

business hours excluding holidays

Former Member
0 Kudos

Hello,

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.

Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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?

amitrathi239
Active Contributor
0 Kudos

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.

Former Member
0 Kudos
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?

Answers (0)