creating proper date

[LAdProg2005]

Hello,

i am in need of help again. somehow i am not getting the correct dates to output8/16 to 8/22 8/9 to 8/15 8/2 to 8/8 7/26 to 8/1 )

Start and end dates of the week is ok but i am getting confused with the loop i think...

<cfset weeks = 4>

<cfset todayDt = Fix( Now() ) />
<cfset stWeek = (todayDt - DayOfWeek( todayDt ) + 1) />
<cfset endWeek = (todayDt + (7 - DayOfWeek( todayDt ))) />

<cfloop index="i" from="1" to="#weeks#">
<cfset formD = #DateAdd("d", stWeek-(7*i), todayDt)# >
<cfset formDt = #DateAdd("d",endWeek+6-(7*i),todayDt)#>
</cfloop>

thanks

 

[cfSearching]

There are a few ways to do it.

<cfset weeks = 4>
 
<cfset today = now() />
<cfset startDate = dateAdd("d", -(DayOfWeek(today)-1), today) />
<cfset endDate = dateAdd("d", (7 - DayOfWeek(today)), today) />

<cfoutput>
 <cfloop index="i" from="1" to="#weeks#">
	startDate = #DateFormat(startDate, "m/d")# 
	endDate = #DateFormat(endDate, "m/d")#<br>
    <cfset startDate =  DateAdd("ww", -1, startDate) >
    <cfset endDate =  DateAdd("ww", -1, endDate)>
</cfloop>
</cfoutput>

BTW, you can lose the extra # signs. They are not needed.

----------------------------------

http://cfsearching.blogspot.com/

 

[LAdProg2005]

works like a charm..

THank you so much....

 

[LAdProg2005]

A question though,

index is not being used...

<cfloop index="i" from="1" to="#weeks#">

The index is not being used..i am looping through the date
and populating the table columns...so using above method...it is not putting the dates in column..

any ideas?

thanks,

 

[cfSearching]

I am not sure I understand. What kind of table: html, database, ..?

----------------------------------

http://cfsearching.blogspot.com/