International Date Values - Access 2007


V

vbasean

Recently I had a problem with MS Access date values between different
countries. I had Spanish dates dd/MM/yyyy actually converting as MM/dd/yyyy
on the US side db. Is this a known bug?

I have the source provider giving me text and then reconverting on my side.
It's very cumbersome because, as many of you may know, when you give someone
an inch they take a mile. Give someone a text field for a date and I promise
you there will be something else other than a date in that field sometime or
another.
 
Ad

Advertisements

J

John W. Vinson

Recently I had a problem with MS Access date values between different
countries. I had Spanish dates dd/MM/yyyy actually converting as MM/dd/yyyy
on the US side db. Is this a known bug?

I have the source provider giving me text and then reconverting on my side.
It's very cumbersome because, as many of you may know, when you give someone
an inch they take a mile. Give someone a text field for a date and I promise
you there will be something else other than a date in that field sometime or
another.

It's not a bug. And it's not "converting" anything.

THe date is stored as a Double Float number, a count of days since midnight,
December 30, 1899. The formatting (dd/mm/yyyy, mm/dd/yyyy, yyyy-mm-dd or any
of scores of other options) is controlled at display time by the format of the
table or query field or the form or report control displaying it.

If you're getting a text file you must know whether the text string
"02-04-2010" refers to February 4 or to el segundo de Avril, and parse it into
your table accordingly.
 
Ad

Advertisements

Å

å¼ å°å»º

vbasean said:
Recently I had a problem with MS Access date values between different
countries. I had Spanish dates dd/MM/yyyy actually converting as
MM/dd/yyyy
on the US side db. Is this a known bug?

I have the source provider giving me text and then reconverting on my
side.
It's very cumbersome because, as many of you may know, when you give
someone
an inch they take a mile. Give someone a text field for a date and I
promise
you there will be something else other than a date in that field sometime
or
another.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top