Date from submitted to database

[evillin]

Hi all

Got a form submitting entries to an Access database.
Does anyone know how to pick up the date the form is submitted to store it in one of the database fields?

I can use server variables to pick up the users IP but seemingly not the date the form is submitted?

Very grateful anyone's thoughts...
thankyou!

 

[bhuninghake]

See if this is what your looking for:

http://www.4guysfromrolla.com/webtech/faq/Intermediate/faq2.shtml

 

[Lothario]

something like this should do...

INSERT INTO mytable(field1,field2,datefield) VALUES (formvalue1,formvalue2,now())


or if you want to enter date in other formats...look into the following link...

http://www.asptutorial.info/learn/Datetime.asp

-L