Mail Merge Date Switch

[dan.cawthorne]

Im Totally Confused Why When I Do a Mail Merge to a word document,

The Date Field I Have Isnt Quite Working Properly.

As The Mail Merge Sets The Date Formate as USA

I Have To Apple a Switch To the Merge Field

The One I'm Using Is MERGE FIELD Requested Date \@ "dd mm yyyy"

Which Seems to Be Working fine on mailmerge document.

But Im My Other One, The Data Reads 17/00/2007 Where as The Date
Should Read 17/08/2007 It Was Working fine Before the Date was set to
August!

I'vei taken the switch off the date will actually Read 08/17/2007

Any One Had Any Issues With This and Solutions?

 

[John W. Vinson]

But Im My Other One, The Data Reads 17/00/2007 Where as The Date
Should Read 17/08/2007 It Was Working fine Before the Date was set to
August!

I'vei taken the switch off the date will actually Read 08/17/2007

Any One Had Any Issues With This and Solutions?

Dan, if you don't mind my asking... Why The Strange Capitalization? It's
really disconcerting to read your posts!

If you're mail-merging you need to be aware that dates are not stored in
Access with any particular format. They're actually stored as a double float
number, a count of days and fractions of a day (times) since midnight,
December 30, 1899. Word will pick up the date from the table in the mail merge
and display it using your computer's Regional settings.

If you want to force a particular format, you can put a calculated field in
the Query you're using for the mail merge:

ExpDate: Format([datefield], "dd/mm/yyyy")

will contain a text string, the date formatted in day-month-year format.

John W. Vinson [MVP]

 

[dan.cawthorne]

But Im My Other One, The Data Reads 17/00/2007 Where as The Date
Should Read 17/08/2007 It Was Working fine Before the Date was set to
August!

I'vei taken the switch off the date will actually Read 08/17/2007

Any One Had Any Issues With This and Solutions?

Dan, if you don't mind my asking... Why The Strange Capitalization? It's
really disconcerting to read your posts!

If you're mail-merging you need to be aware that dates are not stored in
Access with any particular format. They're actually stored as a double float
number, a count of days and fractions of a day (times) since midnight,
December 30, 1899. Word will pick up the date from the table in the mail merge
and display it using your computer's Regional settings.

If you want to force a particular format, you can put a calculated field in
the Query you're using for the mail merge:

ExpDate: Format([datefield], "dd/mm/yyyy")

will contain a text string, the date formatted in day-month-year format.

John W. Vinson [MVP]

Thank you John,

i will give that i try and let you know if i manage to get it to
work,

sorry about the caps its annoying habit, i don't relise i do it.