Update Access with today's date

[Durwood Edwards]

I am creating a form to allow the user to enter new records to an Access
database. I want to have a hidden field that enters the date of record
submission.

Would that be done by setting a value of today() for that named field?

Thanks
Durwood

[TiGGi]

Here's couple of ways to do it:
1.
You can set value of hidden field as #DateFormat(Now(), "mmmm d, yyyy")#, you
can format date anyway you want.
2.
Create Auto Field in access with Date/Time format, so when new record is added
it will time/date stamp it.

Cheers

[Durwood Edwards]

Thanks, I have already set format in Access for the date fileds,so should I
code it thuisly::

<input NAME="date_submission" TYPE="hidden" VALUE="Now()">
?

Thanks
Durwood


"TiGGi" <webforumsuser@macromedia.com> wrote in message
news:c9q3b2$mke$1@forums.macromedia.com...

> Here's couple of ways to do it:
> 1.
> You can set value of hidden field as #DateFormat(Now(), "mmmm d, yyyy")#,

you

> can format date anyway you want.
> 2.
> Create Auto Field in access with Date/Time format, so when new record is

added

> it will time/date stamp it.
>
> Cheers
>

[rob :: digitalburn]

You don't need to do anything at the input end - the database knows what
time it is and can insert it itself :)

[Durwood Edwards]

Well that makes it a lot more simple, now, does it not? Guess I should have
thought about that end of the deal.

Durwood
"rob :: digitalburn" <rob@digitalburn.net> wrote in message
news:c9qbq4$4r3$1@forums.macromedia.com...

> You don't need to do anything at the input end - the database knows what
> time it is and can insert it itself :)
>
>

[rob :: digitalburn]

It does make things pretty easy... :)

Durwood Edwards wrote:

> Well that makes it a lot more simple, now, does it not? Guess I
> should have thought about that end of the deal.