Ok, Maybe not the best title, but let me try and explain:
I have a list of standard opening hours, Monday to Sunday. I can then add specific dates where the hours are different, for example 24th december 2008 09.00 - 16.00 lets say. That's all fine. Now I want users to be able to enter a date range and I'll return them the opening hours for every day in that range (yes, I know but that's what the client wants). So I need to be able to pull all the special opening hours in that range and insert them into the standard opening hours where relevant. Any suggestions on the best way to achieve this? I'm thinking I need to create a structure of dates from the start to the end date, then replace the special opening hours on thoise dates that have one. Does that sound sensible, or am I missing a trick here? My heart always drops when I have to deal with dates and CF - so fernickity. Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
