Microsoft Office Forums Publisher Catalog Merge - Long Date

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-23-2011, 03:59 AM
Jazz43 Jazz43 is offline Publisher Catalog Merge - Long Date Windows 7 64bit Publisher Catalog Merge - Long Date Office 2010 32bit
Advanced Beginner
Publisher Catalog Merge - Long Date
 
Join Date: Oct 2009
Posts: 51
Jazz43 is on a distinguished road
Default Publisher Catalog Merge - Long Date

I have a .pub which catalog merges from a MS Access database.



The catalog merges a date type field which is formatted within the database to show in long format e.g. 23 September 2011 and displays fine within the database table and queries.

My problem is that when the data is merged into the .pub it reformats it into a short date format of mm/dd/yyyy.

Is there any way to stop this, I have trawled for solutions but to no avail, the closest thing I could find would be a work-around to convert the date field within the database to a text field, but if possible would prefer not to do this.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Publisher 2010 only merging first page in multi-page catalog merge non-profit-girl Publisher 0 08-25-2011 06:55 PM
Publisher Catalog Merge - Long Date Mail merge picture into Publisher from URL BlueSprint Publisher 1 07-31-2011 03:06 PM
Publisher Merge sussertown Publisher 0 06-08-2011 03:38 PM
Publisher Catalog Merge - Long Date Wine List, Data Merge - Excel to Publisher - Or other suggestions? daym Publisher 2 05-01-2011 03:45 AM
Publisher Catalog Merge - Long Date Publisher Catalog Merge monkey7759 Publisher 1 01-29-2010 04:53 PM


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


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