Launched Marketo in Nov-16 and during implementation a couple of MyTokens were set-up using Velocity script to convert dates and times, to our local timezone Australia/Sydney:
- {{my.Appt Date}} - for the clients appointment date with consultant
- {{my.Appt Date Time}} - for appointment time with consultant (the actual field it references also includes the date)
The date token is working fine, but the time token is displaying 7 hours later than it should be, (e.g. 5pm instead of 10am). The date and time are pulled from separate Fields in the database.
This is the script that's being used:
#set( $inTimeZone = $date.getTimeZone().getTimeZone('Australia/Sydney') )
#set( $outTimeZone = $date.getTimeZone().getTimeZone('Australia/Sydney') )
#set( $locale = $date.getLocale() )
#set( $myDate = $convert.parseDate(${lead.apptBookedTime},'yy-MM-dd HH:mm',$locale,$inTimeZone) )
${date.format('hh:mm a',$myDate,$locale,$outTimeZone)}
I don't have much experience with Velocity, did a bit of reading online, but can't work out why the above would be showing the time incorrectly.
Can anyone help me solve? Thanks in advance!
Adchoices