Times in VBScript 1

[anastasia]

I am using VBScript within ASP code. I have a form in which a user enters a booking time this is then compared to booking times already booked in a database. What I am using the VBScript for is I am trying to if the time entered in the form is equal to a time held in the database and also if their are times in the range of the time entered by the user plus 15 minutes and less than 15 minutes. So any times that are between the time range plus 15 minutes either way then a booking cannot be made as bookings can only be made 15 minutes apart from each other.

I have tried using Between but the ASP page doesn't seem to like this any suggesions wiuld be welcome.

Thanks.

 

[RobV]

Do you have some code we can check? That would be very helpful. Yours,

Rob.

 

[Swany]

Try this...

I don't know your table names and such, but the pseudo names here should help..

'time that user selected on form
new_appt_time = request("appt_time&quot

'times in the database
sql = "select appt_time from appointments"
rs.open sql, db

do while not rs.eof
appt_time = rs("appt_time&quot
if not((appt_time + 15) > newtime > (new_appt_time - 15)) then
conflict = true
exit do
end if
loop

if conflict = true then
response.write "Scheduling conflict"
response.end
end if

 

[Swany]

quick correction

if not((appt_time + 15) > newtime > (appt_time - 15)) then
' not new_appt_time------------------^

The valueA > valueB > valueC is a BASIC shortcut for "between" If can be read ad "valueB is between valueC and ValueA"