CONVERSION OF DATES

Occasional Visitor

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 

1 Reply

@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)