• Howard Hellman
  • NEWBIE
  • 0 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
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")