Skip to Content
avatar image
Former Member

business hours excluding holidays

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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.

    Add comment
    10|10000 characters needed characters exceeded