Q. How do I save the current date in a table ?

[Jim Jones]

Hi,

I've posted this before, and I forget. It's one of those things I just
can't fix in my mind, on how to do.

I use Access 2K.

I have a records table, and I want to save the current date and time
in the date column.

Example: Employe 3034, on 9/22/2003, finished project.
I want that to be saved in the table.


Thanks,
Jim

 

[Jim Jones]

Use =Now() as the Default Value for the Control that holds the Date and
Time. Don't use either Date or Time as the name of that Control or Field,
because they are Access reserved words and it could cause a problem.

I should have said that I tried Now() as the default value, and this
is what keeps "updating" the date in my table.

I want to record it as a timestamp.

Jim