I have a date that is pulled through as part of a merge field as follows:

and payable on the { MERGEFIELD Contract_DemandDate\@ "d" \Ordinals } day of each month by standing order



The day is split off as expected but for some reason this does not seem to add the ordinals on the end. The merge field is a date and splitting off the day doesn't seem to be a problem but it's almost as if the ordinals and the mergefield are processed at the same time so the ordinals can't be applied to the split off day.

Any help would be appreciated.

Your field switch for the ordinals is wrong. You should be using:
{MERGEFIELD Contract_DemandDate \@ "d" \* Ordinal}

To see how to do just about everything you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at:
http://windowssecrets.com/forums/sho...ation-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Sorry was a typo on my behalf. When corrected still shows:

the 14 day of each month by standing order

instead of:

the 14th day of each month by standing order

The field code, as posted by me, works - even in preview mode. Assuming you do have the field code correct, there may be an issue with your Windows regional settings.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Must be regional settings then. Currently set as UK so not quite sure what else can be done?

UK regional settings won't be affecting it - some European ones could, though, due to differences in separator characters. UK, US, Canada & Australia should all be OK.

If you could attach a copy of your mailmerge main document to a post with some representative data (delete anything sensitive), I'll take a look at it. You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Only managed to attach it to this reply. Data is pulled through as a full date

This is the output:

1. The Landlord lets to the Tenant the residential premises known as Unit 3, Technium, 2 Kings Road, SWANSEA, SA1 8PJ (“the Premises”)
2. The Tenancy will be for a term from and including the 14 Oct 2014 (“the Commencement Date”) to and including 13 Oct 2015 (“the Expiration Date”).
3. The Tenant shall pay to the Landlord or the Agent £1000.00 payable Monthly in advance commencing on 14 Oct 2014 and payable on the 14 day of each month by standing order to HSBC Bank; Account Number 12345678; Sort Code 123456 in the name of Freds Client Accountfirst such payment to be made on the signing of this Agreement for the period from the Commencement Date until the next rent payment date.

Attached Files

legal doc.docx (26.8 KB, 10 views)

Your mailmerge main document looks OK. Can you attach some sample data? I don't need client names/addresses, etc - just the fields containing the data for the «Contract_StartDate», «Contract_EndDate», «Contract_PaymentInterval» & «Contract_DemandDate» outputs.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]