Forum Discussion
CONVERSION OF DATES
DEAR ALL, I HAVE A TABLE WITH DATES IN THE FORM OF DD MMM YYYY. I AM MERGING THE DATA TO A WORD DOCUMENT AND THE DATES APPEAR AS MM DD YYYY. HOW CAN I CORRECT THIS DATE FORMAT IN ORDER TO...
Right-click the date merge field in the Word document.
Select Toggle Field Codes from the context menu.
You will see something like
{ MERGEFIELD MyDate }
or
{ MERGEFIELD MyDate \* MERGEFORMAT }
where MyDate is the name of the date merge field. Make it look like this:
{ MERGEFIELD MyDate \@ "dd MM yy" }
Press F9 to hide the field code and to update the result.
(Please turn off Caps Lock. Using ALL CAPS on the internet is like shouting continuously)