Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem with Merge (2000)

    Hi,

    I seem to have a problem with merging a form to a word document. It is concerning a date field into a word document. It gets displayed as 26/05/05 00:00:00 instead of 26/05/05. I have check the table and form references to ensure that short date is the format and the input mask is 00/00/00;;_

    Any ideas?
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Problem with Merge (2000)

    You can add a formatting switch to the mailmerge field in Word. Right-click the date merge field, and select Toggle Field Codes from the popup menu. You'll see something like { MERGEFIELD DateField * MERGEFORMAT } or { MERGEFIELD DateField }. Immediately after the name of the field, insert a space and type @ "dd/MM/yy" so that it looks like { MERGEFIELD DateField @ "dd/MM/yy" * MERGEFORMAT } or { MERGEFIELD DateField @ "dd/MM/yy" }

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •