Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

Add date/time not working how to fix

Seems like the most simple thing but its not working in this database.  I need to be able for access to add the date and the time when I add the date to a field.  See the attached database.

It is on the notes table.  But it is added from the Contact Form under notes.  I need to add the date and have it add the time the date was added in that same field.   I know this is simple but for some reason it is not working.
1.accdb
0
lehi52
Asked:
lehi52
1 Solution
 
GozrehCommented:
if you are looking for default current date and time, you can set the default to Now()
or if the user can edit the date field, you should add a new field "CreateDate" and set the default to Now()
0
 
lehi52Author Commented:
Simple solution and it worked.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now