[יריב החביב]

Hello,

The date is 06/01/2009 in the datatable (access) but in the merge letter

it is exhibit as 01/06/2009. way, what shold i do ?


thank you
--
תודה רבה

[macropod[_2_]]

Hi yarivr,

To get the date format you want, you can add a formatting picture switch. In Word:
.. select the mergefield;
.. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where 'MyDate' is your mergefield's
name;
.. delete anything appearing after the mergefield's name and add '\@ "d MMMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "d MMMM
yyyy"}. With this switch your date will come out as '2 August 2008'. Other possible date formatting switches include:
. \@ "dddd, d MMMM yyyy";
. \@ "ddd, d MMMM yyyy";
. \@ "d MMM yyyy";
. \@ "dd/MMM/yyyy";
. \@ "d-MM-yy";
Note: you must use uppercase 'M's for months.
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: The above assumes an english-language installation of Word - I don't know whether the day, month & year designations for other
languages is the same.

--
Cheers
macropod
[MVP - Microsoft Word]


"יריב החביב" wrote in message ...
Hello,

The date is 06/01/2009 in the datatable (access) but in the merge letter

it is exhibit as 01/06/2009. way, what shold i do ?


thank you
--
תודה רבה

[יריב החביב]

thank's
--
תודה רבה


"macropod" wrote:

Hi yarivr,

To get the date format you want, you can add a formatting picture switch. In Word:
.. select the mergefield;
.. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where 'MyDate' is your mergefield's
name;
.. delete anything appearing after the mergefield's name and add '\@ "d MMMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "d MMMM
yyyy"}. With this switch your date will come out as '2 August 2008'. Other possible date formatting switches include:
. \@ "dddd, d MMMM yyyy";
. \@ "ddd, d MMMM yyyy";
. \@ "d MMM yyyy";
. \@ "dd/MMM/yyyy";
. \@ "d-MM-yy";
Note: you must use uppercase 'M's for months.
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: The above assumes an english-language installation of Word - I don't know whether the day, month & year designations for other
languages is the same.

--
Cheers
macropod
[MVP - Microsoft Word]


"יריב החביב" wrote in message ...
Hello,

The date is 06/01/2009 in the datatable (access) but in the merge letter

it is exhibit as 01/06/2009. way, what shold i do ?


thank you
--
תודה רבה