add an import date

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

Guest

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
 
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)
 
Back
Top