Hi I have the following mail merge attached which I can't seem to get work correctly..or just don't understand.



The date field is set as 25/01/15 (Uk date)

I have set the delay date as 1 day (just testing)

but the date returned is Sunday, 22 September 2002

why is this? am I missing something?

Regards

Attached Images

MailMergeQuery.png (13.4 KB, 16 views)

The construction from Paul's web site looks correct (and in any case should have been copied from his DateCalc document which you can download from my web site) and if the mergefield really does produce 25/01/15, and the regional date setting is UK English, the field construction will produce Monday, 26 January 2015

The implication therefore is that the mergefield doesn't produce 25/01/15. Have you tried the field without the delay? i.e. { MERGEFIELD RENEW_DATE } ?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Please see attached file checking the date is correctly Pulled and regional settings are correct to my knowledge.

Attached Images

checks.png (23.6 KB, 16 views)

That looks OK, but what does

{ MERGEFIELD RENEW_DATE }

produce.

P.S. Forget that I see you have shown it at the top.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Having mocked up your merge]



{MERGEFIELD RENEW_DATE}

{QUOTE
{SET Delay 1}
{SET a{=INT((14-{MERGEFIELD RENEW_DATE \@ M})/12)}}
{SET b{={MERGEFIELD RENEW_DATE \@ yyyy}+4800-a}}
{SET c{={MERGEFIELD RENEW_DATE \@ M}+12*a-3}}
{SET d{MERGEFIELD RENEW_DATE \@ d}}
{SET jd{=d+INT((153*c+2)/5)+365*b+INT(b/4)-INT(b/100)+INT(b/400)-32045+Delay}}
{SET e{=INT((4*(jd+32044)+3)/146097)}}
{SET f{=jd+32044-INT(146097*e/4)}}
{SET g{=INT((4*f+3)/1461)}}
{SET h{=f-INT(1461*g/4)}}
{SET i{=INT((5*h+2)/153)}}
{SET dd{=h-INT((153*i+2)/5)+1}}
{SET mm{=i+3-12*INT(i/10)}}
{SET yy{=100*e+g-4800+INT(i/10)}}
"{dd}-{mm}-{yy}" \@ "dddd, d MMMM yyyy"}

I get the following results

1/25/2015
Monday, 26 January 2015

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com