Adding current date into a Access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a problem with auto-inserting of the currebt Date
When I'm adding a new line record into a form>>table, I want Access to auto-insert the current Date in the column named DATE of the same table; something like default value, but not a scecified date

I'm sure it can be done easy, but I simply don't know how
Please HELP me, I'm new to Access and I have a project to finish in 3 days. -)
 
For the default value specify:

=Date() 'For the current date
=Now() 'For the current date & time

--
James Goodman
MCSE MCDBA
http://www.angelfire.com/sports/f1pictures/
Mario said:
I have a problem with auto-inserting of the currebt Date.
When I'm adding a new line record into a form>>table, I want Access to
Click to expand...
auto-insert the current Date in the column named DATE of the same table;
something like default value, but not a scecified date.
I'm sure it can be done easy, but I simply don't know how.
Please HELP me, I'm new to Access and I have a project to finish in 3
Click to expand...
days. -)
 
I would also advise renaming the Column as you can see that
Date is a reserved word, being the name of a built-in function.

Hope This Helps
Gerald Stanley MCSD
 
Thank you all

Its working !!! And it was so simple...! :

Sorry for this delay, I simply didn't had time for surfing the net.
 
Back
Top