Gizmos Freeware Reviews  

Go Back   Gizmo's Freeware Forum > Freeware Forum > General Computer Support

Reply
 
Thread Tools Display Modes
Old 21. Dec 2016, 08:44 PM   #1 (permalink)
Member
 
Join Date: Jun 2012
Location: Auckland,New Zealand
Posts: 3
Default Mail Merge Date Format Problem

I am helping to "try" to set up an email confirmation of Paid Membership subscriptions using Mail Merge .
I am in New Zealand where we use the date format Day Month Year unlike USA which is Month Day Year.

Despite the Data source (an Excel xlsx file even an xlx version ) having the Paid Date showing as 14/12/2016 in MS Word it appears after Merge as 12/14/2016

Even if I change the Source Document to USA format and show December 14 2016 in Word after the Merge it still displays as 12/14/2016.

I have tried the various suggestions on Microsoft Community Forum (e.g. adding a switch to the Merge Field) but none works.

Does any GIZMO Forum member know of an Add on or method to overcome this issue?


b) to conclude ,. Merry Christmas ,Rob your efforts are greatly appreciated. Like you I generally save interesting posts re some programs but only end up installing a few.

Thanks
Neil
NeilF784 is offline   Reply With Quote
Old 22. Dec 2016, 03:23 PM   #2 (permalink)
Senior Member
 
Join Date: May 2010
Posts: 552
Default

The date formatting is done at DISPLAY time (if it is held as a date not characters)
All dates are stored internally as a number of days since 1900.
Burn-IT is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT +1. The time now is 09:55 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.