CONVERSION OF DATES

[SAKAR727]

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 APPEAR THE SAME IN WORD AS IN THE ORIGINAL 

[#2]

@SAKAR727 

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)