Velocity Script in Email Token

Question

Hi Community

I am trying to add hours to marketo date and time field which is sync with SFDC custom object and fetch data from SFDC custom object.

Problem here is velocity script is not working in this field, is it because its stored as string not as object?
I have refereed following doc, Adding Days and Comparing Dates

my script goes like this:

#set($x = ${lead.Date}.calendar)

$x.add(10,7)

$x.time

I need to add 7 hour to date that i get in lead.Date field (Originally problems comes because custom object which is sync, does not calculate time zone and i am having 7 hour different in data that I have in marketo, than in SFDC custom object )

any help will be appreciated!

Justin_Cooperm2 · Accepted Answer

I am using blank template to check email script token, There is noting else in email. And Error message is difficult to understand in script level.

email contains

Date = {{lead.Subcription Date:default=edit me}}

Formated Date = {{my.FormattedDate:default=edit me}}

try this:

#set ( $x = $convert.parseDate(${lead.Acquisition_Date},"yyyy-MM-dd hh:mm:ss") )

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

$calendarObj.add(10,7)

$date.format("yyyy-MM-dd hh:mm:ss",$calendarObj)

Justin_Cooperm2 · Answer

try ${lead.Date}.getCalendar()

Sign up

Login with SSO

Login to the community

Login with SSO