times problem between access and asp

times problem between access and asp

Post by gary guyle » Sun, 14 Oct 2001 04:05:27



hi there,
i'm trying to create times in 20 min intervals on an asp page and then
check them against a date/time field(vbshortTime) in an access mdb. if the
time doesnt match as it loops through the recordset the time is printed.
Problem is it works with some times but not with others..is this a delimiter
problem with the created times or something...heres the probable lines of
problem...if this looks ok i'll post the whole page
dim X
X="7:00"
X=DateAdd("n", 20, X)
if X = RS.Fields("time") then...etc....etc

the times are added to the access mdb on another page(works fine) by :
RS.AddNew
RS("time") = request("TimeSelector")
RS.Update

any help appreciated
Gary