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 <[EMAIL PROTECTED]>: > 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/[EMAIL PROTECTED] > > -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]