time field issue in mail merge

macropod · #1 05-02-2012, 01:02 AM

hi Aude,

So what do you get as the output if you don't have any date/time switches? What regional language settings are you using and what is the default time-format separator for these?

Aude · #2 05-03-2012, 12:47 AM

Hi Paul,

There's not formatting on the source data, but the output has got the field switches you recommended above. The language is set to English UK, and time separator is :

The output for the time is the one causing problem, no matter what formatting I try to apply to the source data or field switch in the mail merge, it systematically comes out as 30/12/1899 hh:mm:ss

Aude

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge - If a field is black, take the data from the row below?	mikeprent	Mail Merge	5	01-05-2012 04:52 AM
Use a mail merge Field as the final doc filename	DaveBF	Mail Merge	1	10-22-2011 10:16 PM
HTML Content in Mail Merge Field	Ilmater	Mail Merge	1	09-04-2011 02:47 AM
Mail merge erases field codes	Medievalguy88	Mail Merge	1	08-11-2011 05:21 AM
Mail merge Field Code Manipulation	macjnr	Mail Merge	0	09-10-2009 11:37 AM