Is there a function in the Lotus Notes side of things that can accept a character and convert it to a date?

Seems like you've covered the options, the most direct being passing the date as a character to the Notes ODBC driver.

>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