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


--

[quoted text, click to view]

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