I was having some similar problems an the solution was match the regional setting of the Machine with the type of date expect.
MM-DD-YYYY or DD-MM-YYYY or changing "-" For "/", y another case I need to add the time too.
Did you test the sentence with dbaccess ?
Thanks for the reply. I did check the regional setting and it's setup as yyyy-mm-dd. I have a asp that inserts records w/ dates using this same syntax and that works fine.
I have tried almost every variation date syntax for writing the record to no avail. For now, I'm going to pass the parms to a asp to do the record insert and update. This will allow me to proceed w/ the project and work on the problem later.