+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Formatting Data Fields in Technical; My Head Teacher wants the date on an exclusion letter to have dates formatted as - Thursday, 18th December 2008 ...
  1. #1

    Join Date
    Sep 2008
    Location
    Newcastle upon Tyne
    Posts
    17
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Formatting Data Fields

    My Head Teacher wants the date on an exclusion letter to have dates formatted as - Thursday, 18th December 2008 - as opposed to - 17 Dec 08 - as it appears at the moment. I have tried adding a switch to the <Start Date> merge field and have had some effect but as yet have not got it exactly as I want it.

    Any suggestions


    Cheers and Merry Christmas

  2. #2

    Join Date
    Jun 2007
    Location
    St Marylebone School
    Posts
    13
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Sims won't have a way of altering this, its not particularly good at dealing with mail merge type senarios at a complex level. Hence I suggest one of two solutions:

    1) In the rtf tempate see whether there are any options to fiddle about with field options, particularly field 'switches'. you will have to look on the net to give what you want. don't know whether this will yeild any results, but worth a go.

    2) extract the data into a csv and mail merge from there. only problem will be is if you want to deal with a one-to-many relationship which sounds like you'd want to. the only way round this is to use the csv as a table in an access database and create a report from here.

    sounds like you might have to offer another solution for an easy life!

    good luck.

    Pete



SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] Access - Calculated Fields
    By garethedmondson in forum Office Software
    Replies: 2
    Last Post: 11th December 2008, 04:22 PM
  2. Replies: 1
    Last Post: 3rd October 2008, 12:36 PM
  3. SIMs.net - User defined fields in reports?
    By duncane in forum MIS Systems
    Replies: 4
    Last Post: 21st September 2008, 09:07 AM
  4. Quick letter fields not substituted
    By cjohnsonuk in forum MIS Systems
    Replies: 4
    Last Post: 20th March 2008, 02:42 PM
  5. Help with conditional formatting
    By randle in forum Windows
    Replies: 3
    Last Post: 25th October 2007, 02:20 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
  •