every sunday every month loop

by lokointhehouse2

HTML

<!--- BY Every Week sunday  --->
<cfset today=dateformat(now(), 'mm/dd/yyyy')>

<cfif dayOfWeek(today) gt 1>
    <cfset mostRecentSunday = dateAdd("d", 1-dayOfWeek(today), today)>
<cfelse>
    <cfset mostRecentSunday = dateAdd("d", -7, today)>
</cfif>


<Cfoutput>
<cfloop index = "a" list = "0, 7,14,21,28,35,42,49,56,63,70">
    [#dateformat(DateAdd("d", -a, mostRecentSunday), 'mm/dd/yyyy')#],
</cfloop>
</CFOUTPUT>




<cfabort>

<!--- BY MONTHS  --->
<cfset mydatetime=now()>
<CFSET date1 = #DateFormat(DateAdd('m', -12, MyDateTime),'mmmm dd, yyyy')#>
<CFSET date2 = #now()#>


<Cfoutput>
<Cfset numMonths = DateDiff("m", date1, date2)>
<cfloop index="a" from = "1" to ="#numMonths#">
    [#monthasstring(DatePart("m", DateAdd("m", a, date1)))#],
</cfloop>
</CFOUTPUT>