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 - (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
>
>
>
>
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.15/80 - Release Date: 8/23/2005