Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2017, 05:47 AM
ArieK ArieK is offline Get the right language when inserting a date Windows 10 Get the right language when inserting a date Office 2016
Novice
Get the right language when inserting a date
 
Join Date: Mar 2017
Posts: 4
ArieK is on a distinguished road
Default Get the right language when inserting a date

I make a merge document (to use with CRM Dynamics) which contains a date when this document was made (and may not change when opening the nex day).



So I go to Word 2016 --> Insert tab --> Text group --> Quick parts menu and then click Field.

I choose the CreateDate and in the list "22 maart 2017" (Dutch for March 22 2017".

In the document in will appear as "22 maart 2017".

The fieldcode is CREATEDATE \@ "d MMMM yyyy".

When I save this document and use it to merge with other records in CRM, it will show as "22 March 2017"

How can I get this date to be published as Dutch?

The File --> Options --> Language is set to Dutch.

I use a Dutch version of Word 2016 and the menu etc is shown in Dutch, only this date after merging is set to English.

Anyone an idea what setting is wrong?

Kind regards,

Arie
Reply With Quote
  #2  
Old 03-24-2017, 09:17 AM
Souriane Souriane is offline Get the right language when inserting a date Windows 7 64bit Get the right language when inserting a date Office 2013
Advanced Beginner
 
Join Date: Feb 2017
Location: Quebec, Canada
Posts: 60
Souriane is on a distinguished road
Default

Hi!

You must select Dutch for your text with the Review Tab / Language.

Bye!

Souriane
Reply With Quote
  #3  
Old 03-25-2017, 12:01 AM
macropod's Avatar
macropod macropod is online now Get the right language when inserting a date Windows 7 64bit Get the right language when inserting a date Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,902
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

Cross-posted at: https://www.office-forums.com/thread...-date.2349903/
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 03-31-2017, 02:37 AM
ArieK ArieK is offline Get the right language when inserting a date Windows 10 Get the right language when inserting a date Office 2016
Novice
Get the right language when inserting a date
 
Join Date: Mar 2017
Posts: 4
ArieK is on a distinguished road
Default

Hi Souriane,

Tnx for your answer but in the original document and also in the merge document the language is default set to Dutch in the tab Review --> Language

Kind regards,

Arie
Reply With Quote
  #5  
Old 03-31-2017, 02:44 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Get the right language when inserting a date Windows 10 Get the right language when inserting a date Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,311
Stefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of light
Default

In Word, language is a text attribute, just like bold or italics, so the language at the insertion point may be incorrect even if the default language is correct.

In the Language dialog box (Review | Language | Set Proofing Language), clear the "Detect language automatically" option; that way, you prevent Word from changing the language at the insertion point. The setting applies to all files that you open in Word.

For existing documents whose language formatting is already incorrect, you may have to other choice than to select all the text and manually (re-)apply Dutch via the Language dialog box. Click the OK option (not Set as Default).
__________________
Stefan Blom
Microsoft Word MVP
Reply With Quote
  #6  
Old 03-31-2017, 03:14 AM
ArieK ArieK is offline Get the right language when inserting a date Windows 10 Get the right language when inserting a date Office 2016
Novice
Get the right language when inserting a date
 
Join Date: Mar 2017
Posts: 4
ArieK is on a distinguished road
Default

Hi Stefan,

As you can see below, I have unchecked the "Detect language automatically" but still the date is in English format.



http://picpaste.com/Word-taal-ISScE8HA.jpg

Any clues?

Kind regards,

Arie
Reply With Quote
  #7  
Old 03-31-2017, 03:22 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Get the right language when inserting a date Windows 10 Get the right language when inserting a date Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,311
Stefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of light
Default

Does the language format "behave" in new, blank documents?

If the problem is only with existing documents, (re-)apply Dutch as I describe in my previous post.
__________________
Stefan Blom
Microsoft Word MVP
Reply With Quote
  #8  
Old 03-31-2017, 03:58 AM
macropod's Avatar
macropod macropod is online now Get the right language when inserting a date Windows 7 64bit Get the right language when inserting a date Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,902
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

AFAIK, you need to change the Windows language (via the Control Panel), not just the proofing language in Word.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #9  
Old 03-31-2017, 04:01 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Get the right language when inserting a date Windows 10 Get the right language when inserting a date Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,311
Stefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of light
Default

Good point, Paul.
__________________
Stefan Blom
Microsoft Word MVP
Reply With Quote
  #10  
Old 03-31-2017, 04:11 AM
macropod's Avatar
macropod macropod is online now Get the right language when inserting a date Windows 7 64bit Get the right language when inserting a date Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,902
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

Cross-posted at: https://social.technet.microsoft.com...ate?forum=word
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
I do hope you're not going to make a habit of cross-posting without providing links...
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #11  
Old 03-31-2017, 06:08 AM
ArieK ArieK is offline Get the right language when inserting a date Windows 10 Get the right language when inserting a date Office 2016
Novice
Get the right language when inserting a date
 
Join Date: Mar 2017
Posts: 4
ArieK is on a distinguished road
Default

Hello,

Tnx both for answering!

I have made a new merge document with only the data inserted but still the same problem, in the original document is the date in Dutch but after merging it is in English.

I have checked my Windows Language but that's also in Dutch, see the image below:

http://picpaste.com/Schermopname__1_-mmHlFjXu.png

Kind regards,

Arie
Reply With Quote
  #12  
Old 03-31-2017, 07:50 AM
Charles Kenyon Charles Kenyon is offline Get the right language when inserting a date Windows 10 Get the right language when inserting a date Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,318
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

Quote:
Originally Posted by ArieK View Post
***

I choose the CreateDate and in the list "22 maart 2017" (Dutch for March 22 2017".

In the document in will appear as "22 maart 2017".

The fieldcode is CREATEDATE \@ "d MMMM yyyy".

When I save this document and use it to merge with other records in CRM, it will show as "22 March 2017"

How can I get this date to be published as Dutch?

***
Some ideas displaying my ignorance:

  1. With the field code displayed, select the field and change the proofing language to Dutch.
  2. Is the fieldname CreateDate, itself, different in Dutch?
  3. Would a \CharFormat switch make any difference?
  4. What happens if you switch to a Date field? Any difference?

I know nothing about the effect of language on fields so am simply speculating. I am a typical American as far as language skills go.

One thing I found is that you have to update the field after you change the proofing language.

I checked and the proofing language for the field (not the document, the field) matters. Proofing language is not a system or document setting, it is applied to individual characters.

Once you have found the answer to your question, please post that answer and make a note that your question has been answered in each of the forums where you posted it.
Reply With Quote
Reply

Tags
language, merge, quick parts

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Get the right language when inserting a date Inserting multiple content controls for a date jeffreybrown Word 2 05-09-2016 05:53 PM
Get the right language when inserting a date Inserting the date a spreadsheet was saved into another document Sammie0Sue Office 1 05-15-2014 01:14 AM
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
Get the right language when inserting a date VBA code for inserting a future date cosmopolitan Word VBA 1 08-14-2013 01:58 PM
Get the right language when inserting a date Inserting Date, formatting to superscript and subscript louq Word 1 10-22-2009 09:29 AM


All times are GMT -7. The time now is 02:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft