yeah, i'd bookmark www.cflib.org its the best source of those off-the-wall functions that you think you might be the first to think of...
i know i have used it more than a couple dozen times! good luck tony On 8/30/05, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > Perfect. There ya go Lawrence. It even gives more than my Sunday/Saturday. > > > -----Original Message----- > From: Tony [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 30, 2005 8:29 PM > To: CF-Talk > Subject: Re: Week of year function > > 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 > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216937 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
