Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-26-2019, 10:34 AM
shawn.low@cox.net shawn.low@cox.net is offline Date is displayed in the wrong format Windows 10 Date is displayed in the wrong format Office 2016
Novice
Date is displayed in the wrong format
 
Join Date: May 2019
Location: Aliso Viejo, CA.
Posts: 24
shawn.low@cox.net is on a distinguished road
Default Date is displayed in the wrong format

Trying to investigate this, and it might not be an issue with Word, but I wanted to ask just in case.




I have a Word document that has several "merge" fields. The fields all reference Salesforce.com.
The issue I'm having is this:
The merge field is referencing a "date" field in Salesforce.
The date field is Salesforce show a date formatted like this: 12/26/2019
When I generate the document (using Conga Composer) the date in the Word doc is formatted like this: 2019-12-26.


There are no macros running.


Does anyone have an idea of why Word is displaying the date in a different format then the field in Salesforce.com?


Thank you
Shawn
Reply With Quote
  #2  
Old 12-28-2019, 02:17 AM
Mister B Mister B is offline Date is displayed in the wrong format Windows 10 Date is displayed in the wrong format Office 2019
Novice
 
Join Date: Dec 2019
Posts: 2
Mister B is on a distinguished road
Default

Hi,

I ran into this problem and it bugged me for a long time. Here's the solution:

Microsoft Word: Modify the format of your dates when using the Word Mail Merge feature | Xylos

Regards,
Martin
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date is displayed in the wrong format IF statements in mail merge with results displayed based on date of letter ajh19742000 Mail Merge 1 11-13-2019 01:54 PM
Date is displayed in the wrong format Office 2016 for Mac keeps getting the wrong date for the automatic date susanto_tm Word 10 11-05-2018 05:41 AM
Date is displayed in the wrong format Why is the date/time of comments (and other changes) not displayed in balloons or Reviewing Pane? paulkaye Word 2 12-31-2015 12:38 AM
Date is displayed in the wrong format Documents displayed with wrong layout in Word 2013 MarkM Word 1 10-17-2014 09:45 PM
Wrong date with CreateDate Blablub Word 0 02-18-2010 04:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:51 PM.


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