Looping over times in ColdFusion is the same exact thing as looping over dates in ColdFusion, but sometimes, people don't quite make the mental leap on their own. And so, I thought I would just quickly demonstrate that this was possible.
The key to looping over times is to understand that a time value is really just a fractional date value and that when looping over it, your loop increment (step value) should also be a fractional time value as well. In this case, we are going to loop from 8:00 AM to 5:00 PM using a one hour increment:
Launch code in new window » Download code as text file »
Running the above gives us:
08:00 AM
09:00 AM
10:00 AM
11:00 AM
12:00 PM
01:00 PM
02:00 PM
03:00 PM
04:00 PM
05:00 PM
Notice that in order to get our CFLoop step value, we are building a time span object (returns a Double value) that is created using just a single hour. The mental leap to make here is that that time span value could be anything you want. It could be days, hours, minutes, or seconds.
Just remember, dates are numeric values. Because an indexed CFLoop is iterating over numeric values, ColdFusion accomplishes this by converting your date/time value for the from/to attributes to numeric values behind your back. Embrace this, do not fear it :)
Download Code Snippet ZIP File
Comments (3) | Post Comment | Ask Ben | Permalink | Other Searches | Print Page
Getting Week, Month, And Year Dates Based On A Given Date In ColdFusion
Getting The Decimal Part Of A Number In ColdFusion
That was just what I needed to figure this out, thank.
Posted by Rob W on May 18, 2007 at 10:05 AM
<cfloop
index="EdtTime"
from="8:00 AM"
to="8:00 PM"
step="#dtHour#">
there is an issue with 12 hour time spans, try the above code
Posted by Trent Shepherd on Aug 27, 2007 at 7:12 PM
@Trent,
I just ran this:
<cfset dtHour = CreateTimeSpan( 0, 1, 0, 0 ) />
<cfloop
index="EdtTime"
from="8:00 AM"
to="8:00 PM"
step="#dtHour#">
#TimeFormat( EdtTime, "hh:mm TT" )#<br />
</cfloop>
... and it worked just fine. You have to use the TimeFormat(). Are you? If you don't, it just comes out as fractions.
Posted by Ben Nadel on Aug 28, 2007 at 7:31 AM