469,333 Members | 4,419 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,333 developers. It's quick & easy.

How to retrieve the date of record creation?

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
2 5327
"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
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.

Similar topics

1 post views Thread by kevcar40 | last post: by
4 posts views Thread by wil | last post: by
4 posts views Thread by Simon Gare | last post: by
7 posts views Thread by =?Utf-8?B?UVNJRGV2ZWxvcGVy?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.