Creating automatic dates

[ramsc]

I just created an access database. I wanted to have the date for each record added to the database to be created automatically. If I do this, I was told that all previous records in the database would be changed to the new date that was generated automatically for the specific record on that date. IS this true? Please help,

Thanks

 

[Kjonnnn]

Nah not true

Use Date() in the field properties...

 

[Dreamboat]

To be just a wee bit more specific, use it as the DEFAULT value in the field properties. Anne Troy

http://www.TheOfficeExperts.com

 

[DarkAngel]

Not sure if it matters for your question, but what version of Access are you using?

Adding a field with a date/time stamp will not change the date for previous records (unless you have some sort of macro that does an automatic update). There will be NO VALUE in the new field for any existing records and new records will have the current date/time stamp. Add the record_date field to the table, set the record type to Date/Time, format it the way ya want it, then put Now() as the default value. Hope this helps.