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/
