Dejan
>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."
Well I did have a similar Problem a few weeks ago updating a
sybase Database via ADO.
The problem is that the different SQL-Systems seem to have different ways of handling the datetime-format.
However no one seems to work with the Format VFP does ({^2001-07-05 10:25:22}) and so we received errors on updating the Server-Table. (Also the fields were case sensitive!)
We played around a little and with Sybase it perfectly worked when we
presented the field as a string in the following Format: "2001-07-05 10:25:22"
In this case it seems to be crucial to take care of the Year-Month-day order
and the separator. (We Germans usually say 05.07.2001 and mean July 5th, the Americans would understand the 7th of May)
You should play a little with the strings or have a look in the Notes SQL-Designer, how do they present the data.
Hope this helps
Greetings from Berlin (sun is shining!)
Frank Dietrich