Need help with Velocity Script - Changing date format | Community
Skip to main content
T
TLafferty
New Participant
January 5, 2023
Solved

Need help with Velocity Script - Changing date format

  • January 5, 2023
  • 1 reply
  • 3383 views

I have a customer token, {{my.SupportCase_CreatedDate}}, that displays as yyyy-M-d H:m:s (example: 2023-01-05 12:26:14) when I would rather it display as MMMM d, yyyy (example: January 5, 2023).

 

I'm new to Marketo and scripting so any help would be greatly appreciated. 

 

 

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 SanfordWhiteman
Correct, it is a text my.token.

No, it’s not! You’re describing an existing Velocity {{my.token}} that’s reading a field from Custom Object record.

 

Now first: using .get(0) on a list is never recommended. You should consider the list to be unordered, so getting the 0th item (i.e. the first item) is getting a random item. Explicitly sorting and filtering, then locating the correct focused record, is the correct practice.

 

Assuming you get past that and have a date-like String field, you need to convert it to an actual Date using the methods illustrated here.

 

The output format string for “January 5, 2023” is indeed MMMM d, yyyy.

 

But input format you’re using isn’t really yyyy-M-d H:m:s as you typed. It’s yyyy-MM-dd HH:mm:ss, which is called $ISO8601DateTimeWithSpace in the post. (Though technically it’s not valid ISO 8601 because of the space, and I should’ve called it $NonISODateTimeWithSpace.)

1 reply

SanfordWhiteman
SanfordWhiteman
New Participant
January 5, 2023

This {{my.token}} is a Text token, right?

 

If so — not that I don’t appreciate using a sort-of-like-standard-ISO input format when populating data — why not enter it using the desired output format?

 

You can’t read another non-Velocity {{my.token}} from a Velocity token. So if you wanted to change the format, you’d need to initially enter the value in its own Velocity {{my.token}}, e.g.

#set( $SupportCase_CreatedDate = "2023-01-05T12:26:14Z" )

 

Then you can reformat $SupportCase_CreatedDate in another Velocity {{my.token}}.

T
TLaffertyAuthor
New Participant
January 6, 2023

@sanfordwhiteman - Correct, it is a text my.token. I have no control over the input values unfortunately. Just trying to get them to display in a preferred format if at all possible.

 

This is the field that is within the my.token: ${CaseList.get(0).CreatedDate}

Is this more helpful?

 

Appreciate your help!

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
January 6, 2023
Correct, it is a text my.token.

No, it’s not! You’re describing an existing Velocity {{my.token}} that’s reading a field from Custom Object record.

 

Now first: using .get(0) on a list is never recommended. You should consider the list to be unordered, so getting the 0th item (i.e. the first item) is getting a random item. Explicitly sorting and filtering, then locating the correct focused record, is the correct practice.

 

Assuming you get past that and have a date-like String field, you need to convert it to an actual Date using the methods illustrated here.

 

The output format string for “January 5, 2023” is indeed MMMM d, yyyy.

 

But input format you’re using isn’t really yyyy-M-d H:m:s as you typed. It’s yyyy-MM-dd HH:mm:ss, which is called $ISO8601DateTimeWithSpace in the post. (Though technically it’s not valid ISO 8601 because of the space, and I should’ve called it $NonISODateTimeWithSpace.)

Terms & ConditionsAccessibility statement

Loading footer...