Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jsullinger jsullinger is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
hbean hbean is offline
external usenet poster
 
Posts: 3
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2002 - Insert Date Field that shows "Week Beginning" date onl mokshadavid Tables 2 May 18th 08 01:26 AM
How do I convert a date/time field in a merge field? TEB1824 Mailmerge 5 March 21st 08 06:28 PM
Time shows up instead of a date riri Mailmerge 2 July 17th 07 10:32 AM
How do I correct how a birth date shows in a mail merge field? Grace Mailmerge 1 January 31st 06 09:53 PM
Date mail merge field shows as serial Hiking Mailmerge 5 March 18th 05 10:25 AM


All times are GMT +1. The time now is 08:51 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"