[Marco]

Hi. I already find out my problem. I wasn't using M in upper case. I was
using mm.

Marco

"Marco" wrote:

Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but
then after the mail merge it appears has 01/17/2006.

I tried to format, I change to toogle and format as you told me, I get this
filead:
{Mergefield Data \@ "dd/mm/yyyy" } and this result: 17/00/2006

Why the months apears as zeros?

I even tried to change in Regional Setting the short date to dd/mm/aa but
nothing.

The best that I could get was making a trick. After all register in Excel, I
insert another register and I put some text into the date column.

Any ideas?

Regards,
Marco




"steve roper" wrote:

This helped me and worked fine with same problem

"gb_S49" wrote:

I am trying to complete a mail merge sourced from excel and keep getting the
american date format (MM/DD/YY. despite my efforts I am unable to affect a
change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}