Create Date

[KatieDeaks]

This has got to be a really easy one for you guys...!

I need to record the date/time a record was created - I've tried to use now() but obviously that updates and there appears to be no function for create date...

Can someone help me out please?

Thanks!

Katie

 

[Rod D]

Hi Katie

You are on the right track!
Put the =Now() as the default value in the field property. That will only update the field with the current date and time when a new record is opened.

It might be worth setting the Enabled or Visible property to False to stop the users changing it as well...!

There will be a difference between the time recorded when the new record was opened and when it has been is populated and "saved" so it may not be absolutely 100% accurate - you would have to write a few lines of code for that...

Post back if you need more help.
HTH
Regards
Rod

 

[QuietAchiever]

What about in an old database

Hi, I have inherited a database, and I think it needs a create date in it. I'm glad I found this information. However, because this database already has a heap of records in it, when I put =Now() in a new field on the form, it automatically shows every record as being created on today's date.

Any suggestions?

Okay, I think I've figured it out... the =Now() field needs to be in the underlying data table. Is that right?