Thread: [Solved] Issue with date format in mail merge document
View Single Post
 
Old 11-27-2012, 07:23 PM
walshjod walshjod is offline Windows XP Office 2003
Novice
  
Join Date: Nov 2012
Posts: 2
walshjod is on a distinguished road
Default Issue with date format in mail merge document
I have an Excel 2003 spreadsheet as my data source with the date cell formatted as DD/MM/YYYY.

In my main document I setup the merge field as {MERGEFIELD "Unit_Start_Date" \@ "D MMMM YYYY"}.

When I complete the merge, half of the final document has worked perfectly ie 05/06/2013 displays as "5 June 2013" while the other half of the document is incorrect ie 05/06/2013 displays as "6 May 2013".

I have tried using a calendar control to enter the dates but am still getting the same issue

How do I fix this?
Reply With Quote