Velocity Scripting to Format Date Token | Community
Skip to main content
S
SimoneWi1
Level 2
August 3, 2023
Solved

Velocity Scripting to Format Date Token

  • August 3, 2023
  • 2 replies
  • 2638 views

Hi All!

I have read through the community and haven't found a solution to my problem so I'm hoping someone can help.

 

I need to reformat a date token so it displays like this in the email: MM DD, YYYY

 

Here is the token: {{company.Expire Date (mkto)}}

 

I have tried a few solutions I found in the community but none of them displayed properly for me. I also am not seeing the field 'company.Expire Date (mkto)' pop up in the "tree" so I can't check it off/select it. 

 

I was wondering if I am having trouble because this is a SFDC custom field?

 

If anyone can help, please chime in. Also, if I need to provide any additional information, I'm happy to!

 

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 SimoneWi1

@sahil_kumar_chh  messaged me privately and provided the solution. Shout out to him and everyone else who chimed in to help me! I appreciate it! I just replaced the field ${lead.DateofBirth} highlighted below to make it work for me. Thanks again all.

 

#set( $dateOptions = { "formats" : { "userin" : "yyyy-MM-dd", "userout" : "MMM d, yyyy" }, "timezones" : { "userin" : "America/Los_Angeles", "userout" : "America/Los_Angeles" }, "locale" : $date.getLocale() } ) #set( $myDatelike = ${lead.DateofBirth} ) #set( $myDate = $convert.parseDate( $myDatelike, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) #set( $myDate_formatted = $date.format( $dateOptions.formats.userout, $myDate, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) ${myDate_formatted}

 

2 replies

Darshil_Shah1
Community Advisor and Adobe Champion
Darshil_Shah1Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
August 3, 2023

I think we'd need to see the existing date format of the field. What do you see as output when you just display the unformatted value of that field in an email for a person with a non-empty value?

 

Additionally, Account (or Company) fields can be referenced in the email script token in the Person Object (as $lead.field_name), of course, given that they're visible and synced over to Marketo. Could you open up the Standard Objects >> Person in your email script token's tree on the right and verify whether you're able to see that field?

S
SimoneWi1Author
Level 2
August 3, 2023

Thanks for your quick response. 

Presently, the date is displaying: YYYY-MM-DD

 

I do see it under Standard Objects. Thanks for that tip, I was looking in the wrong area.

SanfordWhiteman
SanfordWhiteman
Level 10
August 3, 2023

Adapt the code from this thread. You should also read the seminal Velocity DateTime post.

    S
    SimoneWi1AuthorAccepted solution
    Level 2
    August 4, 2023

    @sahil_kumar_chh  messaged me privately and provided the solution. Shout out to him and everyone else who chimed in to help me! I appreciate it! I just replaced the field ${lead.DateofBirth} highlighted below to make it work for me. Thanks again all.

     

    #set( $dateOptions = { "formats" : { "userin" : "yyyy-MM-dd", "userout" : "MMM d, yyyy" }, "timezones" : { "userin" : "America/Los_Angeles", "userout" : "America/Los_Angeles" }, "locale" : $date.getLocale() } ) #set( $myDatelike = ${lead.DateofBirth} ) #set( $myDate = $convert.parseDate( $myDatelike, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) #set( $myDate_formatted = $date.format( $dateOptions.formats.userout, $myDate, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) ${myDate_formatted}

     

      SanfordWhiteman
      SanfordWhiteman
      Level 10
      August 4, 2023
      @sahil_kumar_chh  messaged me privately and provided the solution.

      Hmm, that’s unfortunate, as the Nation community is supposed to be for public discussion and public solutions.

       

      In any case the code is taken from the post I linked to (it’s actually my code!).

       

      But you shouldn’t be using the formal reference ${lead.DateofBirth} here. Use the simple reference style $lead.DateofBirth unless you’re outputting values.

        Sahil_Kumar_Chh
        Sahil_Kumar_Chh
        Level 2
        August 4, 2023

        @sanfordwhiteman Definitely. I privately messaged with some inquiries about the field and made some adjustments to the given post by removing the foreach loop.

        Terms & ConditionsAccessibility statement

        Loading footer...