Help with Mail Merge switch for a date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew Pearen - 10 Nov 2003 15:30 GMT

Good day

I have a word mail merge form that I am pulling in
employee data. I have tried to format that date to make it
more readable but the formatting is not changing.
The original field codes view noted;
{ MERGEDFIELD EMP_ADJ_HIRE_DATE }
I edited and changed it to
{ MERGEDFIELD EMP_ADJ_HIRE_DATE \@ "MMM-dd-yyyy" }
without success, no formatting change occurred.
Any help would be appreciated.

Reply to this Message

Peter Jamieson - 10 Nov 2003 17:52 GMT

There's probably a simpler way, but if not, you may need to split the date
up using { = } fields, e.g.

{ SET dt { MERGEFIELD EMP_ADJ_HIRE_DATE } }
{ SET y { =int({ dt } / 10000) } }
{ SET md { = { dt } - ({ y}*10000) } }
{ SET m { =int({ md } / 100) } }
{ SET d { = { md } - ({ m}*100) } }

Then e.g.

{ QUOTE "{ y }-{ m }-{ d }" \@"MMM-DD-YYYY" }

--
Peter Jamieson
MS Word MVP

> Good day
>
[quoted text clipped - 7 lines]
> without success, no formatting change occurred.
> Any help would be appreciated.

Reply to this Message