Date() in the hidden field

Does Date() grab the current date for a form? If I put it in a hidden field
will it submit it to the database at today's date?

I have a hidden field on a form and want it to input the current date into a
database by way of an update form. I have the database set up as a Date/Time
with a short date format. When I got to update using the form I get:

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
expression.

Now the update SQL string has it as being entered as Date (Not text or
number). The Access database has the field set up as Date/Time...so what's
the problem?

Any advice?

What server model are you using?

--
Bill Horvath
Free Tutorials for Studio MX
http://www.communitymx.com/free.cfm
Free 10 Day Trial
http://www.communitymx.com/joincmx.cfm
"Wally Kolcz" <wkolcz (AT) comcast (DOT) net> wrote

Does Date() grab the current date for a form? If I put it in a hidden
field
will it submit it to the database at today's date?

I have a hidden field on a form and want it to input the current date into
a
database by way of an update form. I have the database set up as a
Date/Time
with a short date format. When I got to update using the form I get:

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
expression.

Now the update SQL string has it as being entered as Date (Not text or
number). The Access database has the field set up as Date/Time...so what's
the problem?

Any advice?

Wally,
For ASP, you can set the hidden field's value as:
<%= Date() %>

--
Bill Horvath
Free Tutorials for Studio MX
http://www.communitymx.com/free.cfm
Free 10 Day Trial
http://www.communitymx.com/joincmx.cfm
"Wally Kolcz" <wkolcz (AT) comcast (DOT) net> wrote

ASP/VB