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!