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
|
|||
|
|||
Mailmerge from Access using date fields
Hi got a simple Access database for client details. One field is date of
birth. When merging it into letters etc, the date of birth comes thro back to front. For example, 12 Sept 61, comes thro as 9/12/61, which is the american way around but can be confusing here. I changed the format on the DB to medium date. (12-Sep-61) but still back to front. Can someone advise me? PLEASE!! Many thanks..... Sue |
#2
|
|||
|
|||
Mailmerge from Access using date fields
Format the mergefield with a date formatting switch \@ "d MMM yyyy" -
http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Sue" wrote in message ... Hi got a simple Access database for client details. One field is date of birth. When merging it into letters etc, the date of birth comes thro back to front. For example, 12 Sept 61, comes thro as 9/12/61, which is the american way around but can be confusing here. I changed the format on the DB to medium date. (12-Sep-61) but still back to front. Can someone advise me? PLEASE!! Many thanks..... Sue |
#3
|
|||
|
|||
Mailmerge from Access using date fields
In addition to the method that Graham has suggested, you can also use the
Format() function in a query in Access to force the date into the required format. Format([Datefield], "d mmm yy") will convert the contents of the date field to text in the format 12 Sep 61. -- 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. "Sue" wrote in message ... Hi got a simple Access database for client details. One field is date of birth. When merging it into letters etc, the date of birth comes thro back to front. For example, 12 Sept 61, comes thro as 9/12/61, which is the american way around but can be confusing here. I changed the format on the DB to medium date. (12-Sep-61) but still back to front. Can someone advise me? PLEASE!! Many thanks..... Sue |
Thread Tools | |
Display Modes | |
|
|