>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.
Can you do this?
replace dtfield with 01/01/2000
insert ... (01/01/2000)
then....