List:General Discussion« Previous MessageNext Message »
From:Pooly Date:August 25 2005 1:50pm
Subject:Re: UK Bank Holidays
View as plain text  
Hi,

I guess you have to maintain a table of bank holidays separately,
that's the common setup. I don't know any application that can do it
(even Excel don't do IIRC). Moreover, bank holidays can depend on your
bussiness...

2005/8/25, Shaun <shaunthornburgh@stripped>:
> Hi,
> 
> I need to work out number of business days worked by staff in our company
> i.e.
> 
> 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.
> 
> 
> Shaun
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 


-- 
Pooly
Webzine Rock : http://www.w-fenec.org/
Thread
UK Bank HolidaysShaun25 Aug
  • Re: UK Bank HolidaysPooly25 Aug
    • Re: UK Bank HolidaysRaz25 Aug
  • Re: UK Bank HolidaysPeter Brawley25 Aug