id say this should do the trick.
http://www.cflib.org/udf.cfm?ID=330
tw
On 8/30/05, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
> <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 wouldn't 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
> >
> >
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216930
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
