Why date is changed for no reason?

  • Thread starter Thread starter clara
  • Start date Start date
C

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
 
clara said:
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
 
Back
Top