I have this code to recoed in an Access table called DeleteLog, when a user deletes a document from another table called Documents. However I cannot get the date to work. I want to knoexactly when the document was deleted. Can anyone help?
Set rs = Server.CreateObject("ADODB.Recordset")
vDID = Request.QueryString("DID")
var_date=date() 'get the current date
GetDeletedDocument Conn, rs, vDID 'returns all info about the deleted doc
SQL = ""
SQL = SQL & "Insert INTO DeleteLog (DeletedFrom, ItemDeleted, User, Date)"
SQL = SQL & " VALUES "
SQL = SQL & "('Documents','" & rs("Doc_Title") & "','" & Session("User") & "','" & var_date & "')"