Results 1 to 2 of 2

Thread: Dates (2003)

  1. #1
    Join Date
    Nov 2004
    Thanked 0 Times in 0 Posts

    Dates (2003)

    I have a merge document that has a date imported from an access file. The date e.g. is 24th June 2006 - but it appears 6/24/2006. I would like to have it formatted to read as 24th June 2006 and also 24/6/2006 but cannot see how to do so.

    Please can you help

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Dates (2003)

    I think you'll have to create a query in Access with an extra column that uses the Format function to return the date in the desired format. E.g.
    FormattedDate: Format([DateField],"d mmmm yyyy")
    where DateField is the date field. Use the query as data source for the mail merge, and insert the FormattedDate field instead of the original date field.
    (If you really want -st, -nd, -rd and -th after the number, it becomes more complicated)

Posting Permissions

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