I use the {!Today} function in my emails so that it always shows the current date when an email is sent on a template.
I would like to know how to show an international date in my email templates so that instead of inputting {!Today} and having it come out 7/1/10, I would like it to show as 1-Jul-2010.
Does anyone know the date function for that? Thanks for your help.
1 answer
Found your question from https://sites.secure.force.com/success/ideaView?id=08730000000BraXAAS, in case it's still an issue for you:
I created an email template with the following formula in it to generate the date like 17-APR-2009:
{!DAY(Record.Date)}{!CASE(MONTH(Record.Date),1,"-JAN-",2,"-FEB-",3,"-MAR-",4,"-APR-",5,"-MAY-",6,"-JUN-",7,"-JUL-",8,"-AUG-",9,"-SEP-",10,"-OCT-",11,"-NOV-",12,"-DEC-","-???-")}{!YEAR(Record.Date)}
Record.Date needs to be whatever you're actually wanting the date for, and there should be no spaces between any of the {}'s. For your described need, you can use TODAY() instead of Record.Date.
I'm rather disappointed that this workaround was necessary, but it seems to be doing the job.
