Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Oct 2001
    Location
    Bristol, Bristol, United Kingdom
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Format in Mail Merge (Word 2003)

    Hello. I have a mail merge letter taking fields from a database (which now works - thank you Hans!). One inserted field is a date two weeks from today (i.e. please reply by...). However, the format of this date does not hold and formats the wrong way around (i.e. the American way!). How do I change this merged field to be the good old correct British way? i.e. Today is 22/08/08 and not 08/22/08. The format in the Access database is fine.

    Or is there another way of achieving this without the need of a merged field - the autotext field can be changed to show whatever format required so is there another auto text field i can utilise?

    Many thanks!

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

    Re: Date Format in Mail Merge (Word 2003)

    See <post:=728,696>post 728,696</post:>, and use @ "dd/MM/yy" as date format switch.

  3. #3
    Lounger
    Join Date
    Oct 2001
    Location
    Bristol, Bristol, United Kingdom
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Format in Mail Merge (Word 2003)

    Fantastic - thank you again!

    It is worth noting the capital MM for the month, otherwise the month appears as zeros!

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

    Re: Date Format in Mail Merge (Word 2003)

    The @ switch can be used for date and time formats, and I mentioned only the date codes. Lower case m stands for minutes.

    The time codes are:

    h stands for hours in a 12 hour clock, with h = 1..12 and hh = 01..12
    H stands for hours in a 24 hour clock, with H=1..24 and HH=01..24
    m stands for minutes, with m = 1..60 and mm=01..60
    s stands for seconds, with s=1..60 and ss=01..60
    You can add am/pm or AM/PM to the switch.

    Example: @ "h:mm AM/PM" will result in 1:28 PM

Posting Permissions

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