Email scripting datetime with AM vs. PM | Community
Skip to main content
September 1, 2016
Solved

Email scripting datetime with AM vs. PM

  • September 1, 2016
  • 3 replies
  • 2494 views

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.
Best answer by SanfordWhiteman

The AM/PM macro is lowercase "a".

3 replies

September 1, 2016

Thanks very much!

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

Justin_Cooperm2
New Participant
September 1, 2016

Here are tools available in velocity along with documentation:

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

Justin_Cooperm2
New Participant
September 1, 2016

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

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
September 1, 2016

The AM/PM macro is lowercase "a".