HOW TO GET WEEK NUMBERS WITH CORRESPONDING DATES?

[olchik]

Hello,

I am not sure how to get answer to my question so I tried to ask it in different way. I need to generate drop down box with week numbers and corresponding dates.
For exapmle: Week 1 (01/02/2006 - 01/06/2006)
Week 2 (01/09/2006 - 01/13/2006)
Week 3 (01/15/2006 - 01/19/2006)
and so on... I know I can hard code it and that's it. But I think hardcoding is a bad practice.
PLEASE HELP ME TO CODE IT IN SUFFICIENT WAY!
Thank you

 

[FALCONSEYE]

like this ?
<cfoutput>#Week(now())#</cfoutput>

http://www.jetansolutions.com

 

[olchik]

FALCONSEYE , thank you for your response!
Something like this, but this will give me only THIS week number. I need drop down with this and next year week numbers along with dates.

 

[FALCONSEYE]

ok, will this help?

<cfset startDate = DateFormat(DateAdd("d", -100, now()), "MM/DD/YYYY")>
<cfset stopDate = DateFormat(now(), "MM/DD/YYYY")>

<cfoutput>#
<cfloop index="myDate" from="#startDate#" to="#stopDate#">
DateFormat( myDate, "mmm d, yyyy" )# :: #Week(myDate)#<br>
</cfloop>
</cfoutput>

http://www.jetansolutions.com

 

[imstillatwork]

I tihnk we all forget or never realized that CFLOOP WILL LOOP DATES!

put this into a select with the option values being the START DATE of each week for db storage (trying to store the week num,ber and work with it would be a pain)

<!--- our date (we'll use now if you want to keep this only a current list) --->
<cfset ourdate=now()>
<!--- how many days undil our startdate? (a negative number usually, to fin the previous sunday (the 1=sunday,2=monday,3=tuesday,etc...)) --->
<cfset daysToStartDate = 1 - dayofweek(ourDate)>
<!--- use dateadd to find the startdate for our first week. it may be a previous date if the week began, but we're IN that week so we need to show that range --->
<cfset startdate = dateadd("d",daysToStartDate,ourDate)>

<cfoutput>
<!--- CFLOOP DOES DATES it's easy to forget, but it does dates! starting with our start date, and ending with an end date 
STEP by 7 to loop PER WEEK
(I added 70 dates to loop through 10 weeks)
--->
<cfloop from="#startdate#" to="#dateAdd("d",70,now())#" index="i" step="7">
	<!--- output is simple, formate the dates of the index (i) to get the week startdate, and add 6 days to get the week end date. --->
	#dateformat(i,"mm/dd/yyyy")# - #dateformat(dateAdd("d",6,i),"mm/dd/yyyy")#<br/>
</cfloop>
</cfoutput>

THIS SHOULD BE COPY AND PASTE, ready to go code. you'll just need to add any html to it.

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!

 

[imstillatwork]

sorry, FALCONSEYE!!! your post wasn't in when I started mine. You DO know that cfloop will loop dates.

BTW:

ADD Week #week(i)# to the loop to display the week number like the example showed in the original post.

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!

 

[FALCONSEYE]

it's all groovy

http://www.jetansolutions.com

 

[olchik]

GUYS! YOU ARE THE BEST!!!

That's perfect! Thank you so much for your help!

Olchik

 

[imstillatwork]

no problem.

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!