Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-07-2014, 06:00 PM
macropod's Avatar
macropod macropod is online now Letter date changes when merging with Excel - not the format, the actual date! Windows 7 32bit Letter date changes when merging with Excel - not the format, the actual date! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,341
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As a workaround, you could change your LetterDate variable's format to numeric and store the dates in ISO format (ie YYYYMMDD). You could then use field coding to ensure the stored number is output in whatever date format you require, using a field coded as:
{QUOTE"{=MOD(MOD(DOCVARIABLE LetterDate,10000),100)}-{=INT(MOD(DOCVARIABLE LetterDate,10000)/100)}-{=INT(DOCVARIABLE LetterDate/10000)}" \@ "DDDD, DD MMMM YYYY"}
With this approach, you can change the date switch around to whatever day, month & year order and format you prefer.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format in excel vba LaercioNB Excel 3 08-09-2013 06:33 AM
Letter date changes when merging with Excel - not the format, the actual date! excel 2010 to format a date jassie Excel 1 03-28-2013 02:33 AM
updating status date and actual duration ketanco Project 5 01-27-2012 07:32 AM
Letter date changes when merging with Excel - not the format, the actual date! Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
MS Project able to import actual start and or actual finish date from Excel? mhacker Project 0 04-26-2010 11:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:01 PM.


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