I am updating several hundred customers with some new tables for thier Access Database. I have created a table from SQL code and I am trying to set the tabledef Field.DEFAULTVALUE to the system date. Using the DATE() function.
I am using the tabledef object and this code works for everything but the date. The following code sets the date to the current date, a set value. I want it to set the date on each new record to the system date. Any help would be appreciated.
If fld.Name = "UpdatedOn" Then
fld.DefaultValue = Date()
End If
I am using the tabledef object and this code works for everything but the date. The following code sets the date to the current date, a set value. I want it to set the date on each new record to the system date. Any help would be appreciated.
If fld.Name = "UpdatedOn" Then
fld.DefaultValue = Date()
End If