Date Value Format Error

Tamarrissa · #1 08-06-2013, 09:28 AM

I can't seem to get the date to format properly from excel. This is what I've entered:

{ MERGEFIELD M_10 \@ "dd/MM/yyyy" }

But it still views as the excel value "40623", not "21/03/2011"

macropod · #2 09-29-2013, 07:37 PM

Hi Tamarrissa,

Your problem description suggests you don't only have dates in the M_10 column. Mixing data types often leads to this kind of problem.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date format switch with If statement	sbarron76	Mail Merge	3	05-03-2013 06:23 AM
Help with Date Format and truncating a field	mr starface	Mail Merge	2	04-29-2013 07:08 AM
Timeline date format	mikeg	Project	1	04-19-2013 06:26 AM
MS Query date format	remigio	Word	3	08-21-2012 10:54 PM
date format	gsrikanth	Excel	1	12-28-2011 05:06 AM