List:General Discussion« Previous MessageNext Message »
From:Shaun Date:August 25 2005 11:23am
Subject:UK Bank Holidays
View as plain text  

I need to work out number of business days worked by staff in our company 

Available days = Days in year - (Saturdays + Sundays + Bank Holidays)

(Available Days - Time Off) = Capacity

Is MySQL aware of UK Bank Holidays or do I have to create a separate table 
and keep it updated with Bank Holiday dates?

Thanks for your help.


UK Bank HolidaysShaun25 Aug
  • Re: UK Bank HolidaysPooly25 Aug
    • Re: UK Bank HolidaysRaz25 Aug
  • Re: UK Bank HolidaysPeter Brawley25 Aug