Formatting Data Fields

[tw15ns]

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 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

[peterteckhokgoh]

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