Hidden Field Adds Date to Access Database(NewBie)

[iteach2]

Hi Guru's,

I know this one's easy. I have a field called sign_up_date in DB. I want the date a record was added ex.10/25/03 7:20 p.m - to be added to the sign_up_date field. I tried:

<input type =&quot;hidden&quot; name=&quot;sign_up_date&quot; <%value=&quot;Now()&quot;%>


--but that didn't work.

 

[edrest]

Hi.. iteach2

You don't really hvae to use a hidden field to do this.... just assign the value to the field in your asp file that updates the record....

roughed in code example....

rs(&quot;myfield1&quot= request.form(&quot;whatever&quot
rs(&quot;myfield2&quot = request.form(&quot;whatever2&quot
blah
blah
blah
etc
etc

rs(&quot;sign_up_date&quot = now()

rs.update

I think that now() is going to return the date and time of the server so this may or may not be what you want depending on where your server is located.

HTH....
Tom Gahagan
tgahagan@charter.net

REST



If you get a chance to sit out or dance...

I hope you dance. L Wommack