If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
date format
I have formatted my dates in the underlying MSAccess file as "Short" -
mm/dd/yyyy -- which is what I want.. When the dates come through to the merged Word document they look like this: yyyy-mm-dd 00:00:00 How does one control the date format. Thank you. L Calaway |
#2
|
|||
|
|||
date format
Louise Calaway wrote:
I have formatted my dates in the underlying MSAccess file as "Short" - mm/dd/yyyy -- which is what I want.. When the dates come through to the merged Word document they look like this: yyyy-mm-dd 00:00:00 How does one control the date format. Thank you. L Calaway See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm or, use the Format() function in an Access query to convert the date to text in the format that you want and use the query as the data source. Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. |
Thread Tools | |
Display Modes | |
|
|