14 Replies Latest reply on Jul 3, 2018 10:19 AM by Sanford Whiteman

Set local timezone using Velocity scripts

Nick Koutsioulis Sep 1, 2016 9:37 PM

Hi all.

I am trying to use a script and Velocity to make the output of a date/time field more user friendly.

$date.format('MMMM dd, yyyy hh:mm a z', ${convert.parseDate(${lead.pexa_callbacktime}, 'yyyy-MM-dd')})

I am using the following Velocity script to achieve this, and so far I can successfully change the format, however it changes the timezone on me to GMT. We are in Australia so need this to display AEST (or GMT+10).

The output i get is as follows.

Original Date/Time - 2016-09-14 11:00:00

Output after running through the above script - September 14, 2016 12:00 AM GMT

Any pointers on how to set the location or time zone in the output? I am assuming this is picking up the timezone of Marketo's Apache server.

Thanks

Nick

Re: Set local timezone using Velocity scripts

Sanford Whiteman Sep 1, 2016 11:19 PM (in response to Nick Koutsioulis)
When you first parse the Date from the string (inbound) include the timezone, and remember to include the time itself (you don't have it in your format pattern).

Instantiate the output timezone -- in the below snippet, in and out are the same -- and format the new string (outbound) with that timezone.

#set( $inTimeZone = $date.getTimeZone().getTimeZone('Australia/Sydney') ) #set( $outTimeZone = $date.getTimeZone().getTimeZone('Australia/Sydney') ) #set( $locale = $date.getLocale() ) #set( $myDate = $convert.parseDate($lead.pexa_callbacktime,'MM-dd-yy HH:mm:ss',$locale,$inTimeZone) ) ${date.format('MMMM dd, yyyy hh:mm a z',$myDate,$locale,$outTimeZone)}
3 of 3 people found this helpful
Like Show 0 Likes(0)

Actions
- Re: Set local timezone using Velocity scripts
  
  Jamie Lewis Sep 2, 2016 10:18 AM (in response to Sanford Whiteman)
  
  Thanks Sanford, this is great!
  
  Like Show 0 Likes(0)
  
  Actions
- Re: Set local timezone using Velocity scripts
  
  Nick Koutsioulis Sep 2, 2016 11:43 PM (in response to Sanford Whiteman)
  
  Thanks Sanford, this has worked!
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Set local timezone using Velocity scripts
    
    Sanford Whiteman Sep 3, 2016 12:04 AM (in response to Nick Koutsioulis)
    
    Great. I'm going to do a short blog post on this as it seems to frequently be done incorrectly (people think their Velo tz and instance/Admin tz are the same).
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Set local timezone using Velocity scripts
      
      Matthew Varone Nov 17, 2016 1:41 PM (in response to Sanford Whiteman)
      
      Hi Sanford Whiteman
      
      Im sorry to ask a silly question but how to I apply this to a token on a landing page
      
      Thanks
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: Set local timezone using Velocity scripts
        
        Sanford Whiteman Nov 17, 2016 1:57 PM (in response to Matthew Varone)
        
        In an LP, where Velocity is not available, you can use a tz-aware library like Moment-Timezone.
        
        Like Show 0 Likes(0)
        
        Actions
- Re: Set local timezone using Velocity scripts
  
  fdb29c35d6e1c4df53c3667b8088cef98869c719 Dec 21, 2016 8:20 PM (in response to Sanford Whiteman)
  
  Hi Sanford,
  
  I'm looking to solve the same problem so our company can send a reminder email regarding a training. I'm not sure where I put this script. Is it in the email code header? Or do you add this to a snippet?
  
  Also, I'm guessing I just need to adjust the '$lead.pexa_callbacktime' to the corresponding token field that I would have in this email 'company.Scheduled Training Date'.
  
  #set( $inTimeZone = $date.getTimeZone().getTimeZone('Australia/Sydney') )
  #set( $outTimeZone = $date.getTimeZone().getTimeZone('Australia/Sydney') )
  #set( $locale = $date.getLocale() )
  #set( $myDate = $convert.parseDate($company.Scheduled Training Date,'MM-dd-yy HH:mm:ss',$locale,$inTimeZone) )
  ${date.format('MMMM dd, yyyy hh:mm a z',$myDate,$locale,$outTimeZone)}
  
  Cheers
  
  Travis
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Set local timezone using Velocity scripts
    
    Sanford Whiteman Dec 21, 2016 9:50 PM (in response to fdb29c35d6e1c4df53c3667b8088cef98869c719)
    
    I'm looking to solve the same problem so our company can send a reminder email regarding a training. I'm not sure where I put this script. Is it in the email code header? Or do you add this to a snippet?
    Neither: you create a new Email Script token and the code goes in the editor (left-hand side).
    
    In the tree on the right-hand side, remember to check the boxes next to all fields you want to reference in the code -- in your case the Scheduled Training Date. You should drag the field into the editor to find out the VTL (Velocity) name for the field. It won't be the same as the normal token name because it can't have spaces. For example, {{lead.First Name}} as a normal token is $lead.FirstName in VTL.
    
    Then the name of the Email Script token goes into the email using regular {{my.token}} syntax, for example {{my.velocity_training_date}} or whatever you call it.
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Set local timezone using Velocity scripts
      
      fdb29c35d6e1c4df53c3667b8088cef98869c719 Dec 22, 2016 3:17 PM (in response to Sanford Whiteman)
      
      I've set up the Email Script token as below. It re-arranges the date properly but still reverts to a different time zone.
      
      Training date in salesforce:
      24/05/2016 2:30PM
      
      What shows up with the email token:
      23 May, 2016 11:30 PM EST
      
      #set( $inTimeZone = $date.getTimeZone().getTimeZone('Australia/Sydney') )
      #set( $outTimeZone = $date.getTimeZone().getTimeZone('Australia/Sydney') )
      #set( $locale = $date.getLocale() )
      #set( $myDate = $convert.parseDate($lead.Scheduled_Training_Date__c,'yy-MM-dd HH:mm',$locale,$inTimeZone) )
      ${date.format('dd MMMM, yyyy hh:mm a z',$myDate,$locale,$outTimeZone)}
      
      Any suggestions?
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: Set local timezone using Velocity scripts
        
        Sanford Whiteman Dec 22, 2016 4:35 PM (in response to fdb29c35d6e1c4df53c3667b8088cef98869c719)
        
        Are you in Sydney?
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Set local timezone using Velocity scripts
        
        fdb29c35d6e1c4df53c3667b8088cef98869c719 Dec 22, 2016 4:38 PM (in response to Sanford Whiteman)
        
        Yes.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Set local timezone using Velocity scripts
        
        Sanford Whiteman Dec 22, 2016 5:10 PM (in response to fdb29c35d6e1c4df53c3667b8088cef98869c719)
        
        K, just checking first! I'm on my phone so can't verify the rest. Let me respond later or tomw. I suspect (well, know) that the stored value has a different offset than what's displayed in SFDC, so you have to account for that.
        
        Like Show 0 Likes(0)
        
        Actions
Re: Set local timezone using Velocity scripts

Mark Wallace Jul 3, 2018 4:09 AM (in response to Nick Koutsioulis)

Hello All

Just discovered this and found I can put a webinar into the contacts local timezone using the person time zone field value. Fantastic.

Wanted to check is it possible to put the local campaign tokens into the velocity script. Im currently including the webinar times by putting the webinar times into a field, when they are already in a local token.

If I could put the webinar start time token into the script that would make my day.

thanks for this
Like Show 0 Likes(0)

Actions
- Re: Set local timezone using Velocity scripts
  
  Sanford Whiteman Jul 3, 2018 10:19 AM (in response to Mark Wallace)
  
  What do you mean by "local campaign tokens"? The built-in {{campaign.tokens}}?
  
  Like Show 0 Likes(0)
  
  Actions