Ask Ben: Looping Through The Days In A Month

Posted October 3, 2006 at 8:01 AM by Ben Nadel

Tags: ColdFusion, Ask Ben

How can I loop over the days in a month and do something with each day?

As I have covered before in my blog, looping over dates in ColdFusion is super easy! The beauty of it is that you can treat dates like they are numbers and numbers like they are dates (if it is the right circumstances). All we have to do in this case is start at the first day of the month and loop to the last day in the month:

  • <!---
  • Create the start day of the month to loop through. We
  • need to have an actualy month (of a given year) since
  • of some months (Feb) the number of days per month
  • changes depending on year.
  • --->
  • <cfset dtThisMonth = CreateDate( 2006, 10, 1 ) />
  •  
  • <!---
  • When looping over the days in a month think about what we
  • want to do. We want to basically perform an index loop
  • where on each iteration, the index value is the current
  • day of the month.
  •  
  • In ColdFusion, dates have a string (ex. Oct 1, 2006) and
  • a numeric float value (ex. 38991.0) represenation. We can
  • leverage this to keep adding 1 to the date to get the next
  • day. And how many days do we add? We keep adding until
  • we reach the days in the month.
  • --->
  • <cfloop
  • index="dtToday"
  • from="#dtThisMonth#"
  • to="#(DateAdd( 'm', 1, dtThisMonth ) - 1)#"
  • step="1">
  •  
  • <p>
  • <!--- Display date string. --->
  • <strong>#DateFormat( dtToday, "mmm d, yyyy" )#</strong><br />
  •  
  • <!---
  • Display numeric value. Remember, since we are iterating
  • over the FLOAT values of dates, this should be a float.
  • --->
  • Numeric Value: #dtToday#<br />
  •  
  • <!---
  • Since we have converted the date to its numeric
  • representation, it is no longer a traditional date,
  • but instead, a numeric date.
  • --->
  • IsNumericDate(): #IsNumericDate( dtToday )#<br />
  •  
  • <!--- Double check that it is not a traditional date. --->
  • IsDate(): #IsDate( dtToday )#<br />
  • </p>
  •  
  • </cfloop>

Notice in the above loop that I am loop to the last day in the current month (subtracting one from the start of the next month). We have to do this because the CFLoop index loop is an INCLUSIVE loop. That means it includes both the start and end indexes of the loop range.

The above example give us:

Oct 1, 2006
Numeric Value: 38991
IsNumericDate(): YES
IsDate(): NO

Oct 2, 2006
Numeric Value: 38992
IsNumericDate(): YES
IsDate(): NO

Oct 3, 2006
Numeric Value: 38993
IsNumericDate(): YES
IsDate(): NO

Oct 4, 2006
Numeric Value: 38994
IsNumericDate(): YES
IsDate(): NO

Oct 5, 2006
Numeric Value: 38995
IsNumericDate(): YES
IsDate(): NO

Oct 6, 2006
Numeric Value: 38996
IsNumericDate(): YES
IsDate(): NO

Oct 7, 2006
Numeric Value: 38997
IsNumericDate(): YES
IsDate(): NO

Oct 8, 2006
Numeric Value: 38998
IsNumericDate(): YES
IsDate(): NO

Oct 9, 2006
Numeric Value: 38999
IsNumericDate(): YES
IsDate(): NO

Oct 10, 2006
Numeric Value: 39000
IsNumericDate(): YES
IsDate(): NO

Oct 11, 2006
Numeric Value: 39001
IsNumericDate(): YES
IsDate(): NO

Oct 12, 2006
Numeric Value: 39002
IsNumericDate(): YES
IsDate(): NO

Oct 13, 2006
Numeric Value: 39003
IsNumericDate(): YES
IsDate(): NO

Oct 14, 2006
Numeric Value: 39004
IsNumericDate(): YES
IsDate(): NO

Oct 15, 2006
Numeric Value: 39005
IsNumericDate(): YES
IsDate(): NO

Oct 16, 2006
Numeric Value: 39006
IsNumericDate(): YES
IsDate(): NO

Oct 17, 2006
Numeric Value: 39007
IsNumericDate(): YES
IsDate(): NO

Oct 18, 2006
Numeric Value: 39008
IsNumericDate(): YES
IsDate(): NO

Oct 19, 2006
Numeric Value: 39009
IsNumericDate(): YES
IsDate(): NO

Oct 20, 2006
Numeric Value: 39010
IsNumericDate(): YES
IsDate(): NO

Oct 21, 2006
Numeric Value: 39011
IsNumericDate(): YES
IsDate(): NO

Oct 22, 2006
Numeric Value: 39012
IsNumericDate(): YES
IsDate(): NO

Oct 23, 2006
Numeric Value: 39013
IsNumericDate(): YES
IsDate(): NO

Oct 24, 2006
Numeric Value: 39014
IsNumericDate(): YES
IsDate(): NO

Oct 25, 2006
Numeric Value: 39015
IsNumericDate(): YES
IsDate(): NO

Oct 26, 2006
Numeric Value: 39016
IsNumericDate(): YES
IsDate(): NO

Oct 27, 2006
Numeric Value: 39017
IsNumericDate(): YES
IsDate(): NO

Oct 28, 2006
Numeric Value: 39018
IsNumericDate(): YES
IsDate(): NO

Oct 29, 2006
Numeric Value: 39019
IsNumericDate(): YES
IsDate(): NO

Oct 30, 2006
Numeric Value: 39020
IsNumericDate(): YES
IsDate(): NO

Oct 31, 2006
Numeric Value: 39021
IsNumericDate(): YES
IsDate(): NO




Reader Comments

AMora
Jun 15, 2011 at 1:05 PM // reply »
3 Comments
43 Points

I'm trying to create a list of days. I'm using this to import historical data. I'm getting some odd results. Duplicate dates mostly. Any insights you can provide would be greatly appreciated :-)

Here is what I have:

<cfloop
index="dtThisyear"
from="2008"
to="#year(now())#"
step="1"
>

<cfloop
index="dtThisMonth"
from="1"
to="12"
step="1"
>

<cfloop
index="dtToday"
from="1"
to="#(DateAdd( 'm', 1, dtThisMonth ) - 1)#"
step="1">

<p>

<cfset thisday = "#dtThisyear#-#dtThisMonth#-#DateFormat( dtToday, "dd" )#" />

<cfif isdate( thisday )>

dtThisDay: <cfoutput>#thisday#</cfoutput><br />

</cfif>

</p>

</cfloop>

</cfloop>

</cfloop>


Post A Comment

Comment Etiquette: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.

Please review the following issues:

Author Name:
Author Email:
Author Website:
Comment:
Supported HTML tags for formatting: <strong>bold</strong>   <em>italic</em>   <code>code</code>







  • Help Wanted - Find Your Next ColdFusion Job
InVision App - Prototyping Made Beautiful With Prototyping Tools Ben Nadel's Company - Epicenter Consulting Recent Blog Comments
Bartezz
Feb 10, 2012 at 7:21 PM
jQuery AJAX Strips Script Tags And Inserts Them After Parent-Most Elements
Update! Instead of $(eval(options.insertAfter)).after(data['insertData']); I now use: var ajaxNode = document.createElement('span'); var parent = $(eval(options.insertAfter))[0].parentNode; ... read »
Bartezz
Feb 10, 2012 at 6:18 PM
jQuery AJAX Strips Script Tags And Inserts Them After Parent-Most Elements
encountered this same, what I consider, jQuery bug last week. I'm building a site in which I load some content via AJAX. This content contains Linkedin share button placeholders which Linkedin API ne ... read »
Drew Wells
Feb 10, 2012 at 11:30 AM
Cross-Origin Resource Sharing (CORS) AJAX Requests Between jQuery And Node.js
After you understand the concepts here, this is an awesome cheatsheet for enabling CORS in just about anything http://enable-cors.org/ ... read »
JM
Feb 10, 2012 at 9:10 AM
My Safari Browser SQLite Database Hello World Example
@Amy, Here is a very good tutorial on how to use JOIN: http://www.sqltutorial.org/sqljoin-innerjoin.aspx ... read »
Stefan Richter
Feb 10, 2012 at 4:42 AM
Building A Twitter-Inspired RESTful API Architecture In ColdFusion
This is great, very useful Ben. I spotted a small typo in the api.cgm listing: <cfthrow type="Unauthroized" /> Cheers Stefan ... read »
Hugh
Feb 9, 2012 at 10:35 PM
CFDirectory Filtering Uses Pipe Character For Multiple Filters (Thanks Steve Withington)
I was wondering if there would be a filter you could apply so that you got everything but what you included in the filter. As in show me all docs that are not a .pdf. ... read »
Stephen
Feb 9, 2012 at 10:29 PM
Learning ColdFusion 9: Application-Specific Data Sources
@Ben, No offence, but if people were really wanting advanced features they would be using a platform like ASP.NET MVC. CFML is so structurally compromised as a tag-based scripting language that ... read »
Nathan
Feb 9, 2012 at 10:03 PM
Subversion - Cleanup Failed To Process The Following Paths
@Leviaguirre, do you still have problems with this? ... read »