A Adam Jan 22, 2010 #1 How can I automatically populate the current date into a field for a new record? Will this automation apply a new date to all records?
How can I automatically populate the current date into a field for a new record? Will this automation apply a new date to all records?
D Darrell Childress Jan 22, 2010 #2 Adam said: How can I automatically populate the current date into a field for a new record? Will this automation apply a new date to all records? Click to expand... Set the default value to be Date(). This is done in the table design view. You can, obviously, set the format in the field to show only date, or date and time if you need to know the time of day the record was added.
Adam said: How can I automatically populate the current date into a field for a new record? Will this automation apply a new date to all records? Click to expand... Set the default value to be Date(). This is done in the table design view. You can, obviously, set the format in the field to show only date, or date and time if you need to know the time of day the record was added.
