function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Lady_PirateLady_Pirate 

Need to have opportunity created date in text format in email template

I need to figure out how to have the opportunity created date inserted in an email template (for auto generate) in a text format rather than number format (March 26, 2008 rather than 3/26/08). I can't seem to figure it out.
 
If you have a solution, please advise. Thanks in advance.
JakesterJakester
There might be a really simple way to make Word format your date for you, but I'm not very familiar with creating mail merges, so the solution I would suggest is to create a text formula field (which you don't have to put on your page layout) that goes something like

Code:
case(month(createddate),
1, "January",
2, "February",
etc
) + " " + day(createddate) + ", " + year(createddate)

 
And then put that formula field in your mail merge.
Jamie Rose SilvaJamie Rose Silva
Would it be possible to add a code directly on a custom email template? We have tons of fields in our environment so creating a new field is not really a viable option for me.