Monday, March 31, 2014

SalesForce.com: Date Formatting

Sometimes you may want to return a formula date field such as Today() in a combination text format.  The standard merge field {!Today} returns today's date in numeric format, such as '3/31/2014'.

How can I create a merge field that will return today's date in the format '25 February 2014'?

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()))

2 comments:

devil jiang said...

With the basics already hobbled, director Tim Southam replica handbags deals the episode a fatal blow by thoroughly mucking up the only other hermes outlet question worth asking: how did a hale young man age and die so quickly? The fendi outlet answer is exceedingly boring; more importantly, it confusing. We think we know why by the end, but the explanations smack uncomfortably prada handbags of deux ex machina, and Southam can deliver them with any sense of intensity or excitement.

Jack said...

Together with the existing financial meltdown that's becoming experienced all over the world only a small number of individuals will be ready to waste a great deal on extravagance things Replica Breitling Watches. There are many demanding troubles to take care of Omege Replica Watches, which all want money living costs is perhaps for an all-time large. Having said that Replic watches UK, men and women will always think of options for coping for the duration of these types of low fat situations. To many, abandoning the things they have confidence in is compared to striking their intellect.