Works for me w/o macro substitution

CREATE CURSOR mytable  (mydtfld t)
insert into mytable (mydtfld) value (DateTime())

>I am having a problem with something that I am sure should be simple. I am trying to create an INSERT command with a DateTime type field.
>
>Here is a simplied example:
>
>

>cInsertCommand = "insert into mytable (mydtfld) value (" + ;
>        ttoc(DateTime()) + ")"
>

>
>But when I run this command with
>
>&cInsertCommand.
>
>I get syntax error.
>
>What am I missing?
>
>Thank you in advance for any help.