Date & Time Stamp Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a function to record both the date and time that a record is
created? I want to reproduce the "General Date" Format, "12/20/04 5:32:20
pm" and post it thru a Date/Time Field's default value, automatically at the
moment that a record is created.

Thank you,

Ross
 
Is there a function to record both the date and time that a record is
created? I want to reproduce the "General Date" Format, "12/20/04 5:32:20
pm" and post it thru a Date/Time Field's default value, automatically at the
moment that a record is created.

Thank you,

Ross
Click to expand...

use now() in the defaultValue of the field in the table

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
Andi,

Perfect, thank you!

Andi Mayer said:
use now() in the defaultValue of the field in the table

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Stamp Issue 10
Time Stamp 3
Date Stamp Only When *Field* Changes, not Whenever *Record* Change 4
date/time field converting UTC to default timezone 4
Time Left 4
separating date and time 5
date and time field 4
Extracting only the Date part of a Date/Time field 5

Back
Top