ACCESS DATE FORMAT

  • Thread starter Thread starter GERALD HALES
  • Start date Start date
G

GERALD HALES

When running a query that then exports data from 'Access'
into 'WORD', any fields in date format are always changed
back into the American system (m-d-y). This is despite
the entire computer being set up as English (d-m-y) and
it even happens when formatting is in words, so a date
entered as 3-4-04 (meaning 3rd April 2004) appears in the
WORD document as 4th March 2004. This is very risky when
confirming appointments!! Can anyone tell me what to do?
THIS IS NOT SOLVED BY CHANGING THE REGIONAL SETTINGS AS
THEY ARE ALL ENGLISH!!!
 
It's a royal pain!

There are two approaches:

1) You can explicitly format the date in the Query (using Format ()),
which passes it as a string with the format you want.

2) You can use a format suffix with the Merge Field - I forget the
details, but I think that Word Help does, for once.

When running a query that then exports data from 'Access'
into 'WORD', any fields in date format are always changed
back into the American system (m-d-y). This is despite
the entire computer being set up as English (d-m-y) and
it even happens when formatting is in words, so a date
entered as 3-4-04 (meaning 3rd April 2004) appears in the
WORD document as 4th March 2004. This is very risky when
confirming appointments!! Can anyone tell me what to do?
THIS IS NOT SOLVED BY CHANGING THE REGIONAL SETTINGS AS
THEY ARE ALL ENGLISH!!!
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Look up "Date Switches" in Word Help.

It's a royal pain!

There are two approaches:

1) You can explicitly format the date in the Query (using Format ()),
which passes it as a string with the format you want.

2) You can use a format suffix with the Merge Field - I forget the
details, but I think that Word Help does, for once.




Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
When running a query that then exports data from 'Access'
into 'WORD', any fields in date format are always changed
back into the American system (m-d-y). This is despite
the entire computer being set up as English (d-m-y) and
it even happens when formatting is in words, so a date
entered as 3-4-04 (meaning 3rd April 2004) appears in the
WORD document as 4th March 2004. This is very risky when
confirming appointments!! Can anyone tell me what to do?
THIS IS NOT SOLVED BY CHANGING THE REGIONAL SETTINGS AS
THEY ARE ALL ENGLISH!!!
Click to expand...

You will need to explicitly use the Format() *function* to convert the
date field to a text string and export that string rather than the
date. That is, put

ExpDate: Format([datefield], "dd-mm-yy")

as a field in your query and use it in the Word export.
 
Back
Top