G
Guest
Can anyone help with this statement which is not working?
Set dbs = OpenDatabase("c:\db1.mdb")
dbs.Execute "ALTER TABLE [tblAL] " _
& "ADD COLUMN DF DATETIME(Short Date);"
I am trying to add a DATETIME column in Short Date format but not sure of
syntax for the Short Date format.
If it was a Text column of lenght 100 then it would be simply be Text(100)
Set dbs = OpenDatabase("c:\db1.mdb")
dbs.Execute "ALTER TABLE [tblAL] " _
& "ADD COLUMN DF DATETIME(Short Date);"
I am trying to add a DATETIME column in Short Date format but not sure of
syntax for the Short Date format.
If it was a Text column of lenght 100 then it would be simply be Text(100)