+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Date Format in SIMS Quick Letters in Technical; At present, our Quick Letters are set to print the date as 04/09/2012, using the <Date> flag in the merge ...
  1. #1
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75

    Date Format in SIMS Quick Letters

    At present, our Quick Letters are set to print the date as 04/09/2012, using the <Date> flag in the merge document. I would like to change this to show a long date, i.e. 4 September 2012, but can't work out how. Any offers?

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Easiest thing to do is to insert a traditional Word Date field and set it to auto-update. You can choose any formatting you want.

  3. #3
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,207
    Thank Post
    451
    Thanked 174 Times in 171 Posts
    Blog Entries
    3
    Rep Power
    64
    I editted the macro in the 2003 template, not sure if you can do the same in 2010 (with the macro security, haven't tested it yet).

  4. #4
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    I'm missing something here - I changed C:\Program Files\QuickLetterTemplate.doc, and when I edited the font, it was fine, but when I also edited the date field I broke the macro which adds the details into the letter. What am I doing wrong?

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    There's a Quick Reference Sheet for QuickLetters, that discusses making a local copy and putting it in your my sims documents. This should be in your my documents and if roaming profile, follow you around. This may help, as the program files folder is probably a protected location if you're on windows 7. Not sure if that may have any impact.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Sims Report in Word/Excel changes date format
    By Chunks_ in forum MIS Systems
    Replies: 10
    Last Post: 25th August 2012, 12:39 PM
  2. Replies: 6
    Last Post: 10th May 2011, 06:26 AM
  3. Custom date format in SIMS Report
    By pod in forum MIS Systems
    Replies: 6
    Last Post: 2nd November 2009, 12:37 PM
  4. sims "quick letters" permissions
    By browolf in forum MIS Systems
    Replies: 2
    Last Post: 26th September 2008, 02:06 PM
  5. Dates in SIMS reports
    By cjohnsonuk in forum MIS Systems
    Replies: 0
    Last Post: 19th March 2008, 12:25 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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