Would this work for you?
<cfoutput>
#DateFormat(DateAdd("d", "-#DayOfWeek(Now()) - 1#", Now()), "dddd, mmmm d,
yyyy")#
</cfoutput>
On 5/10/07, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote:
>
> 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
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277463
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
