Formatting the TODAY Date in Email Template

If you have ever inserted the current date for example in an email template you know it formats at MM/DD/YYYY (e.g., 05/10/2011). 

If you want it to display as 10 May , 2011 or some other formatting, the trick is to have your administrator create a custom formula field on the USER record that re-formats this date and then you can use this field (Send User Field) in your template.

This can be achieved by setting up on the User object a custom formula field that will return (as a text) the desired date format.

Once this field has been set up, you can use it as a merge field in your email templates, instead of the standard {!Today} merge field.

The formula to be used in the custom formula field is the following:

TEXT(DAY(TODAY()))&" "&CASE(MONTH(TODAY()),1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November","December")&" "&TEXT(YEAR(TODAY()))