| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date field Shows Time too
I am having issues with the date field in a mail merge document from Access
2007. The field is a date/time field with only date, no time. However, in the Word mail merged document, the date and time is showing, and in a format other than what is selected on the Access side, ie. 2008-06-02 00:00:00. Any ideas how to correct it to show only 02-06-2008? |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Date field Shows Time too
On Feb 9, 9:40*am, jsullinger
wrote: I am having issues with the date field in a mail merge document from Access 2007. The field is a date/time field with only date, no time. However, in the Word mail merged document, the date and time is showing, and in a format other than what is selected on the Access side, ie. 2008-06-02 00:00:00. Any ideas how to correct it to show only 02-06-2008? You should be able to get the date to show up in the format you want by using the \@ date switch - just do a search in your help for date- time picture switch and it will give you a whole bunch of options for date and time. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word 2002 - Insert Date Field that shows "Week Beginning" date onl | Tables | |||
| How do I convert a date/time field in a merge field? | Mailmerge | |||
| Time shows up instead of a date | Mailmerge | |||
| How do I correct how a birth date shows in a mail merge field? | Mailmerge | |||
| Date mail merge field shows as serial | Mailmerge | |||
Hybrid Mode
