How to retrieve the date of record creation?

[Jeroen Elias]

Hello,

Is it possible to retrieve the date when a record is created in an Access
database table?
And if so, how can I do that?

Thanks in advance,
Jeroen Elias

[Anthony England]

"Jeroen Elias" <j.*****@bluedesk.nl> wrote in message
news:6c***************************@cache30.multika bel.net...

Hello,

Is it possible to retrieve the date when a record is created in an Access
database table?
And if so, how can I do that?

Thanks in advance,
Jeroen Elias

No - there is no built-in way. You would have to add a field to the table
called something like 'CreatedOn' and set its type to DateTime. You can
then give it a default value of Date() for just the date or Now() for the
time and date.

[Jeroen Elias]

Dear Anthony,

Thanks for your reply. I was afraid for that.
I will apply your solution to future databases ;-)

Thanks again,
Jeroen Elias
"Anthony England" <ae******@oops.co.uk> wrote in message
news:du**********@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...

"Jeroen Elias" <j.*****@bluedesk.nl> wrote in message
news:6c***************************@cache30.multika bel.net...

Hello,

Is it possible to retrieve the date when a record is created in an Access
database table?
And if so, how can I do that?

Thanks in advance,
Jeroen Elias

No - there is no built-in way. You would have to add a field to the table
called something like 'CreatedOn' and set its type to DateTime. You can
then give it a default value of Date() for just the date or Now() for the
time and date.