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


--
thank you so much for your help

Andrew Morton

clara wrote:
> 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