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

like :-
<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

date_mod=', /',

I am obviously missing something

Please Help

Topshed

Additional, I confirm what is in date_mod before the Update and I get

5/26/2005

Topshed

If not your code is too big, can you post that here. I dont think this info is sufficient to find what you are missing.

_________________________
- Vijay G
Strive for Perfection