Velocity Script in Email Token

[Anonymous]

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]

try ${lead.Date}.getCalendar()

[Anonymous]

I am getting error in script while trying send sample email,

[Kenny_Elkington]

Can you paste a copy of your current script?

[Anonymous]

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

$x.add(10,7)

$x.time

[Kenny_Elkington]

Doesn't look like the issue is in the script itself.  Could you share the whole HTML of the Email?  There is probably an issue parsing somewhere further along

[Anonymous]

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}}

[Justin_Cooperm2 · Accepted solution]

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)

[Anonymous]

Thanks Justin, it helped

-Indu