I'm building an app where I am keeping track of sales on a weekly basis, so I am storing the number of the week (as a tinyint) and the year (as a smallint). Now there is a requirement to generate a report where the date of the first day of the week (i.e. 5/13/2007 being the date fo the first day of week 20 of 2007). While I can certainly rebuild this portion of the app, I would prefer not to. Any ideas on how to convert a week/year into the first date of week/month/year format using either MS SQL Server of CF7?
Thanks Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
