How can I change the type of a field from text to date/time with a macro?
J Jan van Hooff Dec 2, 2004 #1 How can I change the type of a field from text to date/time with a macro?
S Steve Schapel Dec 3, 2004 #2 Jan, Use a RunSQL action in your macro. In the SQL Statement argument, put the equivalent of... ALTER TABLE NameOfYourTable ALTER COLUMN NameOfField DATE
Jan, Use a RunSQL action in your macro. In the SQL Statement argument, put the equivalent of... ALTER TABLE NameOfYourTable ALTER COLUMN NameOfField DATE
