Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date format (office xp)

    Access date set by Regional settings (d/m/yy or dd/mmm/yy - Australian) however when merging in Word always prints as m/d/yy (american). How do I overcome. Sheena

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

    Re: Date format (office xp)

    You can solve this in Access or in Word.

    In Access:

    If your data source is a table, create a query based on that table and use that as data source instead.
    So now I'll assume that your data source is a query.
    Convert the date to a string in the desired format by putting a column in the query defined like
    <pre>MyDate: Format([InvoiceDate],"d/m/yy")</pre>

    (replace field names by the appropriate names and modify the format string as desired)

    In Word:

    In your merge document, turn on field codes (Alt+F9). Your merge fields should look like
    <pre>{ MergeField InvoiceDate }</pre>

    You can add formatting:
    <pre>{ MergeField InvoiceDate @ "d/M/yy" }</pre>

    The @ switch is for date and time formatting.
    Don't forget to turn of field codes (Alt+F9 again) and to update the merge field (click in it or select it and hit F9).
    This method may cause problems if the date field contains nulls (empty values).

Posting Permissions

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