<cfset mydate = "8-7-2005">
<cfset FirstDayOfWeek = DayofWeek(mydate)>
<cfset FirstDayOfWeek = DateAdd("D", "-#FirstDayOfWeek-1#", mydate)>
<cfset LastDayOfWeek = DateAdd("D", 6, FirstDayOfWeek)>
<cfoutput>
#DateFormat(FirstDayOfWeek, "MM-DD-YYYY")#<br>
#DateFormat(LastDayOfWeek, "MM-DD-YYYY")#
</cfoutput>
That should return 8-7-2005 and 8-13-2005 (Sunday through Saturday)
-----Original Message-----
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 7:30 PM
To: CF-Talk
Subject: RE: Week of year function
I think my typing outran my brain on that one. That wouldnt work... now I
feel obligated to redeem myself so I'll give it another shot and get back to
you
-----Original Message-----
From: Lawrence [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 6:28 PM
To: CF-Talk
Subject: Week of year function
Hello,
Is there a function that allows me to search by the week number? What I
mean is, there are 52 weeks in the year, is there a function where I can
enter week number 12, and CF will search on dates that fall within that week
of the year without me having to know what those dates are?
I know there is a function where I can enter a date and retrieve the week
number if falls in - Week(date) - I'm looking for one that
sort of works the other way around - something like this - WeekDates(week
number,year) This would return two variables - the starting Sunday date and
the ending Saturday date. If there isn't one like this, there should be.
:-)
Thanks!
--
Lawrence Cramer
----- Original Message -----
From: "CF-Talk" <[email protected]>
To: "CF-Talk" <[email protected]>
Sent: Tuesday, August 30, 2005 3:00 PM
Subject: CF-Talk: Digest every 4 hours
> CF-Talk 30-Aug-05 Issue:4718
> In this issue:
> 1 ColdFusion Failover costs 8-10x more than a standalone serv er!
> 1 ColdFusion Failover costs 8-10x more than a standalone serv er!
> 1 ColdFusion Failover costs 8-10x more than a standalone serv er!
> 1 ColdFusion Failover costs 8-10x more than a standalone server!
> 1 ColdFusion Failover costs 8-10x more than a standalone server!
> 1 ColdFusion Failover costs 8-10x more than a standalone server!
> 1 ColdFusion Failover costs 8-10x more than a standalone server!
> cffunction must be used inside of cfcomponent? am I going crazy??
> cffunction must be used inside of cfcomponent? am I going crazy??
> Get double quotes string inside another string
> keeping servers synchronized
> keeping servers synchronized
> keeping servers synchronized
> Odd SSL problem
> Odd SSL problem
> Odd SSL problem
> Paging through records
> Paging through records
> Paging through records
> Paging through records
> Paging through records
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216925
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
