Andyatwork
Board Regular
- Joined
- Mar 29, 2010
- Messages
- 94
Hello all,
A colleague has stumped me with this problem. A mail merge involving a UK format date from excel 07 to Word 03 selectively ignores the field codes set in the Word document.
The date should be 2nd July 2013, displayed as 02/07/2013, but comes out as 07/02/2013.
Now, we are not strangers to mail merges and complete hundreds if not thousands a week. We have double checked:
The field codes are correctly set for dd/MM/yyyy and they work for other records from same merge source to the same word doc.
The date value is definitely entered in excel as numbers (not text), also formatted as UK date in excel
Tried connecting by DDE and OLE DB, and this has no effect.
If they were all coming out in US format MMddyyyy i could understand it, but it is the fact that only a handful of dates out of 100s are flipping back from UK to US.
Anyone else experienced this and have a solution?
Many thanks,
A colleague has stumped me with this problem. A mail merge involving a UK format date from excel 07 to Word 03 selectively ignores the field codes set in the Word document.
The date should be 2nd July 2013, displayed as 02/07/2013, but comes out as 07/02/2013.
Now, we are not strangers to mail merges and complete hundreds if not thousands a week. We have double checked:
The field codes are correctly set for dd/MM/yyyy and they work for other records from same merge source to the same word doc.
The date value is definitely entered in excel as numbers (not text), also formatted as UK date in excel
Tried connecting by DDE and OLE DB, and this has no effect.
If they were all coming out in US format MMddyyyy i could understand it, but it is the fact that only a handful of dates out of 100s are flipping back from UK to US.
Anyone else experienced this and have a solution?
Many thanks,
