> Good idea, there must be a SQL function for that maybe? I know how to do
not that i know of, but you should probably approach this from the db anyway. while its easy enough to find weekends (being careful about locales where weeks don't start the same as other places) what about holidays? most businesses here in thailand don't count holidays as business days, even better some thai-american ones don't count either thai or us holidays. i usually maintain a table with relevant holidays & weekends dates & work against that. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
