ok thanks for that got it working, i am trying to populate a
list box but the time it is showing is 1 hour ahead of what it
should be
IN MY TABLE
GetUser.starttime = 08:00:00
GetUser.EndTime = 12:00:00
GetUser.Increment = 60
so in my list box it should show times 08:00 to 12:00 but it
shows 09:00 to 01:00
any ideas why this is?
<select name="APPT_Time">
<cfset steptime = GetUser.starttime>
<cfloop condition="DateCompare(StepTime, GetUser.EndTime)
LT 1">
<cfoutput query="GetUser">
<cfset StepTime = dateadd("n", GetUser.Increment,
StepTime)>
<option value="#TimeFormat(StepTime,
"hh:mm:ss")#">#TimeFormat(StepTime, "hh:mm")#
</option>
</cfoutput>
</cfloop>
</select>