Timestamp to database

my form is a HTML form because I just modified the one in use by my company, the action on posting is to call the asp app to process the form, therefore all of my additions to the access database from the ASP side are like:

rsAddComments.Fields('User') = Request.Form('user')
etc..

how do I add the date to the database field 'Date'

rsAddComments.Fields('Date') = ??????

i know the code for the date is something like %=Date() but how do I assign it to that field?

Thanks

 

Isn't this ASP rather than ASP.Net?


If it's ASP you should post this in the classic ASP forum where I'm sure you'll have more luck.