What about using the Date() Function instead? Another thing to look into is a Notes OLE-DB Provider. Right now, you are using the Notes ODBC Driver. If you use SQL-Passthrough, what is the behavior? Does it work correctly.

When you return data from notes, what does VFP thing the data type fo the date field is? If you use SQL Passthrough, is it the same data type. Having to change the date field to a text type on the backend to me, does not seem like a good idea. In a pinch, it may work, but it is far from an optimal solution.

Hopefully, these debugging suggestions will help...




>Hi All,
>
>I am having trouble updating the notes datetime type field. If i change type to text then i can write no problem.
>
>Column name is DATE type datetime
>code that it fails
>
>rs.FIELDS("Date").VALUE = datetime()
>
>it actually fails on rs.update
>
>The error is that OLEDB Provider for ODBC driver
>Lotus Notes ODBC driver " Data value is not valid date, time or timestamp."
>
>
>I tried putting the character, converting DateTOCharacter(datetime()) to no avail.
>
>Only if i change in Notes designer DATE type field from datetime to text I can write to it.
>
>
>I am using Notes R5 designer and Client and Lotus Notes ODBC ver 3.00 driver on Win NT machine.
>Testing with VFP6 and VB6 using ADO 2.5
>
>
>Please help.
>
>Thanks
>
>Dejan