Updating date fields

[Mighty]

I am using an ASp program with ADO to update date fields in a Pervasive table. I have the following command:

rs("DUEDATE_28&quot = dueDate

where rs is my recordset and dueDate is a variable containing the date I want the field updated to.

My question is - what format does dueDate need to be in as I am getting errors when I try to update the record with rs.Update saying that there is a problem converting the date. Mise Le Meas,

Mighty

 

[Linda84]

What datatype does table definition specify for the DUEDATE_28 field? Many people store dates as strings instead of actually using the Date data type.

What format is dueDate? Standard ODBC requires dates to be in the format yyyy-mm-dd.

 

[Mighty]

dueDate is a BTrieve Date.
I have tried assigning a date in the btrieve format i.e. YYYY-MM-DD and just using the date format on my pc, i.e. dd-MMM-yy and neither was successful so I just abandoned it and used an sql query to complete the update. Mise Le Meas,

Mighty