How can I loop instead of hardcoding this info

Forum|Forum|13 years ago
June 18, 2012
1 reply
2401 views

Hi all

I have the following code, how can I cfloop and dynamically output this info instead of having to have each meeting time? Thanks

</cfselect>

This topic has been closed for replies.

Correct answer -__cfSearching__-

Hi Dan, thanks I tried this it is almost working, I get all the times in half hour intervals from 8 - 5.30 but in the wrong date!! {ts '1899-12-30 08:00:00'}

<cfset startweek_dt = TimeFormat(YourDateTime, "hh:mm") >
<cfloop index="ii" from="1" to="20">
<cfset startweek_dt = DateAdd('n',30, startweek_dt)>
<cfoutput>#startweek_dt#</cfoutput><br>
</cfloop>

I get all the times in half hour intervals from 8 - 5.30 but in the wrong date!! {ts '1899-12-30 08:00:00'}

It is not the wrong date. Since you only specified a time (ie "07:30AM") the "date" portion defaults to 0 or 12/30/1899 . If you needed a specific time and date, you must specify it when creating the variables. For example:

<cfset YourDateTime = createDateTime(2012, 6, 25, 7, 30, 0)> ... or

BUT .. in your case it does not make a difference because you are not using the date for anything. So just use timeFormat() to display the time only.

ie #timeFormat( yourVariableName, 'hh:mm:ss tt')#

D

Dan_Bracuk

Inspiring

Use cfloop condition = "YourDateTime lte #MaxDateTime#"

inside your loop use DateAdd to increment YourDateTime and use TimeFormat to display it.

A

Anonymous

Like this Dan? Thanks

<cfloop condition = "YourDateTime lte #MaxDateTime#">
#timeFormat(dateAdd('n', 30, YourDateTime),'hh:mm:ss tt')#
</cfloop>

D

Dan_Bracuk

Inspiring

Did it work when you ran it?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded