AnsweredAssumed Answered

Date format when using Substitute or Merge

Question asked by Annette on Feb 27, 2014
Latest reply on Feb 27, 2014 by philmodjunk


Date format when using Substitute or Merge



     I was just wondering if there is a way to format the way a date appears if you are using substitute or merge fields?

     I have letter templates where I use substitution of fields where I have certain text, some of those are date fields and it always defaults to dd/mm/yyy format but sometimes in a letter I would like it to have the date written in long format.  

     To give you an idea of what I mean I have two fields, one is letter text (text field), the other letter body (calculation).  In the letter text I have the letter template.  Dear <<NAME>>, thank you for your letter which I received on <<LetterReceiptDate>> etc etc.  Then the Letter Body field substitutes <<NAME>> with the Name field of that record, <<LetterReceiptDate>> with the date.

     Seems like a small thing but sometimes the date just looks better in letters written out in long format.  

     Thanks for any help!