Why date is changed for no reason?

[clara]

Hi all,

I just retrieve a date field into a texbox, but the date has changed when it
is read from database. The database is designed by others,I not sure whether
there is something wrong in database or in coding?

Clara

 

[Andrew Morton]

I just retrieve a date field into a texbox, but the date has changed
when it is read from database. The database is designed by others,I
not sure whether there is something wrong in database or in coding?

Can you give us an example of the date change?

I suspect it is because somewhere something uses dates in a format like
MMddyy and elsewhere dates are expected to be in a ddMMyy format.

If it's an Access database, then you can use Locale Identifier in the
connection string, e.g. for en-gb
"driver={Microsoft Access Driver (*.mdb)};DBQ=C\mydatabase.mdb;Locale
Identifier=2057"

Andrew