By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,656 Members | 1,917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,656 IT Pros & Developers. It's quick & easy.

How to retrieve the date of record creation?

P: n/a
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

Feb 28 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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.
Feb 28 '06 #2

P: n/a
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.

Mar 1 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.