Legacy code problem

[John]

Hi

I am stuck with using some legacy code in my app for time constrain reasons
so please accept my apologies for this. I am using the below code;

rs = New ADODB.Recordset
....
ALLDAYend = fmtDateTime(CDate(rs.fields("company_allday_end")), "hh:mm:ss")

and I am getting a 'Value of type 'ADODB.Field' cannot be converted to
'Date'.' error. Could someone please let me know how can I fix it?

Many Thanks

Regards

 

[Thomas Hansen]

Hi

I am stuck with using some legacy code in my app for time constrain reasons
so please accept my apologies for this. I am using the below code;

rs = New ADODB.Recordset
...
ALLDAYend = fmtDateTime(CDate(rs.fields("company_allday_end")), "hh:mm:ss")

and I am getting a 'Value of type 'ADODB.Field' cannot be converted to
'Date'.' error. Could someone please let me know how can I fix it?

Try DateTime.ParseExact...!!

..t