ACCESS DATE FORMAT

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!!!
 
J

John Vinson

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.
 
Top