Macro to change fieldtype

[Guest]

How can I change the type of a field from text to date/time with a macro?

 

[Steve Schapel]

Jan,

Use a RunSQL action in your macro. In the SQL Statement argument, put
the equivalent of...
ALTER TABLE NameOfYourTable ALTER COLUMN NameOfField DATE