Using DATETIME and GETDATE() using ExecuteSQLDDL

[Sausagefingers]

Hi,
been banging my head against a wall for the last two to three hours trying to figure out something so simple that when I do get the answer, I'll feel like kicking myself. Hope you can prevent me from doing too much damage

I'm trying to create a series of tables using 'ExecuteSQLDDL "CREATE TABLE....' For example:

ExecuteSQLDDL "CREATE TABLE tbl_zone (strZone TEXT (3), lngZoneID AUTOINCREMENT NOT NULL PRIMARY KEY, blIsActive BIT, blIsInact BIT, dtZneDate DATETIME, etc ...);"

What is the correct syntax for generating a record date or time stamp??

Please help!

Thanks in advance.