Skip to main content
September 1, 2016
Solved

Email scripting datetime with AM vs. PM

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)

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
September 1, 2016

The AM/PM macro is lowercase "a".

5 replies

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
September 1, 2016

The AM/PM macro is lowercase "a".

Translate
Justin_Cooperm2
Level 10
September 1, 2016

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

Translate
September 1, 2016

Thanks very much!

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

Translate
Justin_Cooperm2
Level 10
September 1, 2016

Here are tools available in velocity along with documentation:

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

Translate