Help with Mail Merge switch for a date

[Andrew Pearen]

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.

 

[Peter Jamieson]

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" }