Reading Dates from ADO

[MattWoberts]

Hi,

I have an ADO Recordset that contains a date. I need to copy the date to a string, and then do some formatting... easy enough, but how do I know the date format. Depending on the PC setup, the date can be formatted dd/mm/yy or mm/dd/yy.....is there a way I can deal with this and convert whatever is in the recordset to dd/mm/yy???

Thanks

Mattwoberts

 

[Guest_imported]

As far as I know, the date stored in the recordset is of type Variant(VT_DATE). If you want to keep it in a form you can work with in C++ and be able to put it back into a database as a Variant(VT_DATE), put it into a COleDateTime variable. I think one of the class members of COleDateTime might have what you are looking for.

 

[MattWoberts]

Thanks, but I am using ATL - not MFC, so I dont have access to those handy classses :-(