Monday, January 10, 2011

Long Date Access Database Translate Short Date In Word

This is about microsoft word trouble when i was trying to make mail merge from microsoft word with access database, i've got a small problem to write a long date format. The Problem is from microsoft office word 2007 that can't read long date from access, microsoft word translate long date to short date.

I has trying to searching online with Internet with my best friend (google is my best friend to learn something that i don't know because google is more smart from me, hehehe) with google i has found the problem resolve.

Open your word document that have short date problem :
1. select the mergefield;
2. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD YourDate} where 'YourDate' is your mergefield's name;
3. After the mergefield's name you must add \@ "d MMMM yyyy" to the field, as in {MERGEFIELD MyDate \@ "d MMMM yyyy"}.
4. With this switch your date will come out like '2 August 2008'. Other possible date formatting switches include :
a. \@ "dddd, d MMMM yyyy"
b. \@ "ddd, d MMMM yyyy"
c. \@ "d MMM yyyy"
d. \@ "dd/MMM/yyyy"
. \@ "d-MM-yy";

Note: you can swap the d, M, y expressions around, but you must use uppercase 'M's for months - lowercase 'm's are for minutes.

5. position the cursor anywhere in this field and press F9 to update it;
6. run your mailmerge.

Now have a fun with your long date mailmerge in the word without a problem.