Re: UK Bank Holidays

2005-08-25 Thread Peter Brawley
Shaun >Is MySQL aware of UK Bank Holidays Nope. > or do I have to create a separate table >and keep it updated with Bank Holiday dates? Yep. PB - Shaun wrote: Hi, I need to work out number of business days worked by staff in our company i.e. Available days = Days in year - (Saturd

Re: UK Bank Holidays

2005-08-25 Thread Raz
Shaun, This is a great opportunity for you to be creative and... > I guess you have to maintain a table of bank holidays separately, ...add some of your own in. Brill! Raz ;) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

Re: UK Bank Holidays

2005-08-25 Thread Pooly
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