Date Token Improper Formatting question

[Anonymous]

Hey y'all,

We are trying to send a type of "account update" to our customers with fields such as "remaining balance," "minimum payment due," and "next payment date."

We have everything else figured out, but there seems to be an issue with the way we have our token set up for "Next Payment Date." The date is coming in correctly from our database, but when it pops out in the email due to the token, it comes out as "2016-07-13" instead of "July 13, 2016." At least it pops out a date, but we are trying to make it look prettier than that.

Any fixes or scripts to help our our custom tokens?

[David_Gaible]

Hi David.

I hate to be the bearer of bad news, but you're out of luck on this one. Date tokens are not easily editable. Go vote for this product improvement idea! ​. If you want to take a dive into Velocity scripting, you could edit the format. This article may help: http://developers.marketo.com/documentation/velocity-script/

[Chris_Saporito]

Hi David,

Check out Ryan Huber comments in this post: Date Format Velocity Script This should point you in the right direction

[SanfordWhiteman]

Actually the date conversion examples there are buggy because they aren't attentive to time zones.  My code here takes pod and instance timezones into account to avoid such errors: Set local timezone using Velocity scripts