+ Start a Discussion
Howard HellmanHoward Hellman 

Converting Date Field to look like Date/Time Format in an email forward

I am looking to take a date/time field and make it look like an email forward date.
I am looking to create an email template that looks like an email forward. The goal is to create a workflow for a new field 'Last Email Sent Date' inside of the field use a formula to achieve the folliwng.

"Sunday, January 10, 2016 10:59 AM" 

I am getting the following error message

Error: Syntax error. Missing ')'

After reading through the help discussion and help posts, I am assuming this is the correct formula for the inpute field
CASE(
  MONTH( date ),
  1, "January",
  2, "February",
  3, "March",
  4, "April",
  5, "May",
  6, "June",
  7, "July",
  8, "August",
  9, "September",
  10, "October",
  11, "November",
  "December",

CASE(
  MOD( date - DATE( 1900, 1, 8 ), 7 ),
  0, "Monday",
  1, "Tuesday",
  2, "Wednesday",
  3, "Thursday",
  4, "Friday",
  5, "Saturday", 
  "Sunday"
)
 DATEVALUE("EEEEE, MMMMM dd, yyyy hh:mm a")
Andy BoettcherAndy Boettcher
Time is a hard one to do in formulas - you can do the math against it, but returning a formatted value right now is logged as an Idea on the IdeaExchange.

You can try following this link to accomplish what you're looking to do:  http://salesforce.stackexchange.com/questions/46780/how-to-convert-date-format-of-now-to-mm-dd-yyyy-in-formula-editor