SOLVED

Email scripting datetime with AM vs. PM

Go to solution
Anonymous
Not applicable

Hey Marketo community,

Might anyone have suggestions for adding AM vs. PM to the output of the script below. A sample of the current output is "Thursday September 1, 2016 5:00". I want to have "...5:00 AM" or "...5:00 PM". Thanks in advance for the help.

#set($dateObj = $convert.parseDate(${Milestone1_Project__cList.get(0).Customer_Approval_Call_Date__c}, 'yyyy-MM-dd hh:mm'))

## Convert to a calendar objectand perform time zone adjustments

#set($calendarObj = $convert.toCalendar($dateObj))

#if (${Milestone1_Project__cList.get(0).Time_Zone__c} == "EST")

  $calendarObj.add(10,1)

#elseif (${Milestone1_Project__cList.get(0).Time_Zone__c} == "CST") 

  $calendarObj.add(10,0)

#elseif (${Milestone1_Project__cList.get(0).Time_Zone__c} == "MST") 

  $calendarObj.add(10,-1) 

#elseif (${Milestone1_Project__cList.get(0).Time_Zone__c} == "PST") 

  $calendarObj.add(10,-2) 

#end

$date.format('EEEE MMMM d, yyyy h:mm',$calendarObj)

1 ACCEPTED SOLUTION
SanfordWhiteman
Level 10 - Community Moderator

The AM/PM macro is lowercase "a".

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Thanks very much!

Sanford and Justin, do you either know of documentation resources so I can learn more about Velocity scripting?

SanfordWhiteman
Level 10 - Community Moderator

Can't help but recommend the Velocity pieces on my blog: blog.teknkl.com/tag/velocity.  I have some big Velocity-related posts coming up, always with a Marketo focus.

Justin_Cooperm2
Level 10

Here are tools available in velocity along with documentation:

org.apache.velocity.tools.generic (VelocityTools 2.0-beta4 Documentation)

Justin_Cooperm2
Level 10

$date.format('EEEE MMMM d, yyyy h:mm a',$calendarObj)

SanfordWhiteman
Level 10 - Community Moderator

The AM/PM macro is lowercase "a".