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