Dumb date to record question
When updating a record on the web I want to automatically put a current date into a record field to give me a last update record
I have been trying but all I get is a "/" which gives me aSyntax error in UPDATE statement.
If I remove the date part it all works fine
I have tried both a date and a text data types but it make no differance
<input type="hidden" name="date_mod" value="<%=rs("date_mod")%>" />
in a form, followed by
date_mod = DateValue(date)
Then in my update
SQLstmt = SQLstmt & "date_mod='" & TRIM(Request.Form("date_mod")) & "', "
the result on a response.write for the update is
I am obviously missing something