Paste date

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have a data base that I would like every time I add a
record to it the current date would be added and kept.
What would the best way to do this be? So if I added 1
record or 100 records today the date added would show
5/18/2004. Then if tommorow I added 1 or 100 records the
date would be 5/19/2004. That way I could sort by dates
that I added something.
I guess I will need to make a field for the date but how
do I get the date to be in there automaticly without
having to type it in each time.

Thanks Rick
 
Open your table in design view.

Enter the new date/time field, and in the lower pane, set its Default Value
to:
=Date()

If you wanted it to record the time as well as the date, set the
DefaultValue to:
=Now()
 
Rick, Open your table in design mode. Add a new field to the bottom(i.e..
dtToday). In the right column set the data type to Date/Time. At the
bottom of the screen set the Format to what you want(i.e. Short Date). In
the Default Value type in "=Date()" (no quotes). Now for every new record
the current date will be added.
 
Back
Top