I ran up into a problem.
In a rdoResultset, i'm trying to add a new record.
Example code:

with rstemp
.rdcolumns(1).value = field(1).text
.rdcolumns(2).value = field(2).text
end with

the field 2 in the db is a date type kind of one.
when i do .batchupdate, so it writes the changes to the database, i get a error, saying error in SQL statement, while doing INSERT INTO.
I tried formatting the date value all possible ways, but i still get the error.
How can I format the date value in field(2).text, so it will pass the sql insert into statement?

Thanx to anyone who can answer this!