The solution, though, lies outside of Sesame. It's to use Word's field switches.

Firstly, in your merge document, show the field code rather than the result. To do this click on the field and press Shift F9, or press Alt F9 to toggle all field codes.

Click at the end of the field code and add the appropriate switch.  For example, change ..

{MERGEFIELD Date}
to 
{MERGEFIELD Date \@ "MMMM dd, yy"}

Where "Date" is the column heading ("field name") of the field in question. The field code starts with the \ character.

By this means you can vary the number of decimal places for numbers, format dates any way you want, and turn numbers into currency amounts.  Here are some examples...

Dates

\@ "MM/dd/yyyy"     produces         11/19/2003
\@ "MM-dd-yy"      produces         11-19-03
\@ "dd MMM yy"      produces         19 Nov 03
\@ "dddd, MMMM d, yyyy"   produces    Wednesday, November 19, 2003

Numbers & Currency
     
Example = 1237.852941

\#0.00      produces  1237.85
\#0      produces             38
\#$#,###.00      produces      $  1,237.85
\#£#,###      produces      £  1,238


Text

\* Upper      produces  NY  from "ny"
\* Caps    produces   New York  from "new york"

Once you've set the field code, press Shift F9 to display the value again. Don't be alarmed - it will still show the previous formatting. Press F9 to 'refresh' the field.

This is described in the Programming Guide pages 242-243.

==============
above is copied from explanation given by Alec in the earlier link in regards to the similar question.

http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=gen_disc;action=display...

Quote:


What program are you using to produce the mail merge document?

This topic has been discussed with workaround in the following link.

http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=gen_disc;action=display...

[quote author=Bharat_Naik  link=1077331704/0#6 date=1077461572]Since you are concerned about Date formating (merging in other than Word), you might have to make one more text field and convert the internally stored date into the format you desired by Sbasic code.

The date is internally stored as YYYY/MM/DD

Let's say Date1 is the date field
TextDate it a new text field you are adding

for 12/31/2003 format
===============
TextDate = @STR (@MONTH(DATE1)) + "/" + @STR (@DOM (DATE1)) + "/" + @STR (@YEAR (DATE1))

for 31/12/2003 format
==============
TextDate = @STR (@DOM (DATE1)) + "/" + @STR (@MONTH(DATE1)) + "/" +  @STR (@YEAR (DATE1))

[/quote]

Thanks people :) . . . me being the non programming type ended up working out the following solution to my problem, which works too! LOL . . .

for 12 December 2004 Format . . .

SUPPORTEXPIRES (DATE) - Original Date Field
SUPPORTEXPIRESTEXT (TEXT) - Converted Date Format Field

IF @MID(SUPPORTEXPIRES, 6,2) = "01" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "January" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "02" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "Febuary" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "03" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "March" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "04" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "April" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "05" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "May" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "06" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "June" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "07" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "July" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "08" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "August" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "09" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "September" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "10" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "October" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "11" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "November" + " " + @MID(SUPPORTEXPIRES, 1,4)
ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "12" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "December" + " " + @MID(SUPPORTEXPIRES, 1,4)

Quote:


Sheesh, thanks a heap Carl, you can tell im not a programmer