Issue with date format in mail merge document

walshjod · #1 11-27-2012, 07:23 PM

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
time field issue in mail merge	Aude	Mail Merge	16	05-18-2014 06:22 AM
Date picker mail merge error.	dan1	Mail Merge	7	06-28-2012 03:00 AM
Mail merge will not format date field generated by Excel IF statement	borntorun75	Mail Merge	3	12-16-2011 06:28 AM
Date not transfering to mail merge correctly	tonywatsonmail	Mail Merge	1	07-01-2011 05:30 AM
Word 2007 mail merge issue	steelervince	Mail Merge	0	02-17-2010 02:26 PM