add an import date

[coconutt]

I have a table of patients that I must update weekly based on there accounts
aged. I import a standard excel file each week to update my table. My
question is, how can I add a date field to indicate what date the patient
record was imported.

Thanks
Coconutt

 

[Douglas J. Steele]

Assuming you're importing into an existing table, add a field to the table
with its default value set to Date() (if you only want the date) or Now()
(if you want the date and time)