>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.

Dmitry,
Why are you trying to create such a string in the first place? Is it a cursoradapter or SQLExec() string? If so you better use parametric insert. ie:

cInsertCommand = "insert into mytable (mydtfld) values (?m.ltDatetime)"
m.ltDatetime = datetime()
SQLExec(m.lnHandle, m.cInsertCommand)

If not (sounds not as you're trying macro substitution) then why not directly have the command itself instead of creating a string first:

insert into mytable (mydtfld) values (m.ltDatetime)

If you still want it as a string I don't understand why you need a conversion when you're already doing a macro substitution:

cInsertCommand = "insert into mytable (mydtfld) values (DateTime())"
*or
cInsertCommand = "insert into mytable (mydtfld) values (m.ltDatetime)"
m.ltDateTime = ...
&cInsertCommand

Cetin