Hi everybody,
When I use the following to add a record to a database
rs.addNew
rs("ReplyTo") = ReplyToID
rs("mID") = Request.cookies("IsLogged")("mid")
rs("Topic") = Topic
rs("Message") = Message
rs("DateTime") = Now
rs("IP") = Request.ServerVariables("REMOTE_HOST")
rs.Update
It adds the correct NOW date in rs("DateTime") today is 12-08-2003
But when I use the following to add the NOW date to a diferent table
db.execute("Update tblTopic set LastDate = '" & Now & "', Replies = Replies
+ 1 where PostID = " & ReplyToID)
It adds the NOW date as 08-12-03
both rows have the same settings, DATE/TIME with format GENERAL DATE
Any suggestions ?
Thanx,
Willem-Jan Selen