Skip to Content
0

business hours excluding holidays

Nov 16, 2017 at 10:01 AM

24

avatar image
Former Member

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.

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

1 Answer

Best Answer
AMIT KUMAR
Nov 16, 2017 at 10:35 AM
0

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
Former Member

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?

0

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.

0
Former Member
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)
0