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