View Single Post
 
Old 09-23-2011, 03:59 AM
Jazz43 Jazz43 is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Oct 2009
Posts: 54
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