Date format when exporting to Excel

[Fiona]

Hi
We have a database used by several people. They often export data to Excel
by right-clicking the table and choosing Export. This normally works fine
but on a couple of occasions, dates have been converted from dd/mm/yyyy to
mm/dd/yyyy - not all of them but just those that make sense that way round.
eg 01/04/2000 converted to 04/01/2000 but 23/07/2000 stayed the same.

I have tried to reproduce the problem unsuccessfully. For example, if I
change the international setting to US, all the dates convert.

Any ideas what might be causing this?

Fiona

 

[PieterLinden via AccessMonster.com]

Hi
We have a database used by several people. They often export data to Excel
by right-clicking the table and choosing Export. This normally works fine
but on a couple of occasions, dates have been converted from dd/mm/yyyy to
mm/dd/yyyy - not all of them but just those that make sense that way round.
eg 01/04/2000 converted to 04/01/2000 but 23/07/2000 stayed the same.

I have tried to reproduce the problem unsuccessfully. For example, if I
change the international setting to US, all the dates convert.

Any ideas what might be causing this?

Fiona

Don't know for sure, but it sounds like Access is using the US Date format as
the default, so any date that can be interpreted as being in US format is
exported that way. I would create a query that forces the format into US
format and then export from there. Sounds retarded, but that should solve
the problem.

 

[Fiona]

Thanks
Yes I suppose that's the answer. It's annoying because I' like to know why
it's happening. Oh well...
Fiona

 

[Gina Whipp]

Fiona,

I would make sure everybody has the same Date format in Windows since that
is where Access draws it from.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm