View Single Post
 
Old 11-27-2012, 10:30 PM
walshjod walshjod is offline Windows XP Office 2003
Novice
 
Join Date: Nov 2012
Posts: 2
walshjod is on a distinguished road
Default

The issue is not mixed data format in the source as I have checked this (I even recreated the column from scratch). Also there isn't any problem with the coding for the switch - my mail merge is to create letters that contain the date ie the date format is correct on some letters but not others.

I don't think I have explained my problem very well. Below is an example of the output of my mail merge:
10/01/2013 Tuesday, 1 October 2013 (This is incorrect)
15/01/2013 Tuesday, 15 January 2013 (This is correct)
05/03/2013 Friday, 3 May 2013 (This is incorrect)
27/03/2013 Wednesday, 27 March 2013 (This is correct)
It seems that the Word can only create the date in the format that I want when the day is greater than "12".

Surely there has to be a work around.
Reply With Quote