There probably is but...
If the day of the year is greater than 7, divide it by 7 for the week number else it is week 1 Very likely that youll get a decimal number so just listfirst with . as the delimiter Not tested... <cfif DayOfYear(myday) gt 7> <cfset weekofyear = listfirst(DayOfYear(myday), ".")> <cfelse> <cfset weekofyear = 1> </cfif> Or something close to that -----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" <cf-talk@houseoffusion.com> To: "CF-Talk" <cf-talk@houseoffusion.com> 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:216918 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