Hello to everyone and anyone. I'm new to ASP and to this forum.

Here's what I'm having a problem with. I need ASP to do the following:
(1) take the starttime in one database field (SQL Server), (08:00:00 AM)
(2) take the endtime in another database field (SQL Server), (05:00:00 PM)
(3) add 30 minutes to the starttime, and
(4) display the result of the each new starttime.

It needs to continue to do these steps until the new starttime is less than or equal to the endtime. My code produces an infinite loop for whatever reason. Here's my code.

<%
Dim strSatOpen
Dim strSatClosed
Dim strSatapptframe
Dim addTime

strSatOpen = ("8:00 AM")
strSatClosed = ("5:00 PM")
strSatapptframe = "30"
addTime = DateAdd("n",strSatapptframe,strSatOpen)

Do While addTime <= strSatclosed
Response.Write "<br>" & addTime
addTime = addTime + strSatapptframe
%>

Any and all help is greatly appreciated. :)

Try:
----------------------
strSatOpen = cDate("8:00:00 AM")
strSatClosed = cdate("5:00:00 PM")
strSatapptframe = "30"
addTime = DateAdd("n",strSatapptframe,strSatOpen)

Do Until cdate(addTime) = cDate(strSatClosed)
   addTime = DateAdd("n",strSatapptframe,addTime)
   response.write cdate(addTime) & "<br>"
loop
----------------------

FYI: The cDate function - Returns an expression that has been converted to a Variant of subtype Date

BTW: you forgot the LOOP - All Do While and Do Until conditions must be closed with a LOOP



Wind is your friend
Matt

pupadu

People will be less inclined to answer your questions if you cross post (unless you clearly get no response in one area)

Wind is your friend
Matt

Thanks for the tip and the solution, mat41. I'm new to forum so please bear with me.