How to format a date type? | Community
Skip to main content
A
Anonymous
January 27, 2014
Solved

How to format a date type?

  • January 27, 2014
  • 7 replies
  • 2767 views

Is there a way to format a date that I am calling to a landing page through tokens to depict it in DD-MMM-YY? MMM represents first three alphabets of a month - JAN, FEB, MAR etc.

Thanks in advance for your help.

Best regards,
Ajay
 

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
One option would be the new custom formatting. 

Defining a custom field and using a regular expression for Change Data Value would work smoothly.

REGEX_REPLACE
Replaces patterns matched by a regex with a replacement string
 
Syntax:
##REGEX_REPLACE(<token or value>,"/<regular expression>/", <replacement token or value>)##
 
Example :
##REGEX_REPLACE("Hello *#&^ World","/^[A-Za-z0-0]/","_")##
returns "Hello ____ World"


In that context you can easily format as DD-Month-YY.

7 replies

A
Anonymous
Accepted solution
January 27, 2014
One option would be the new custom formatting. 

Defining a custom field and using a regular expression for Change Data Value would work smoothly.

REGEX_REPLACE
Replaces patterns matched by a regex with a replacement string
 
Syntax:
##REGEX_REPLACE(<token or value>,"/<regular expression>/", <replacement token or value>)##
 
Example :
##REGEX_REPLACE("Hello *#&^ World","/^[A-Za-z0-0]/","_")##
returns "Hello ____ World"


In that context you can easily format as DD-Month-YY.

A
Anonymous
January 27, 2014
Way cool! Thanks for sharing this!!
A
Anonymous
January 27, 2014
Sharing the other functions as well. While they are not directly related to that discussion they can be used for future reference

TRIM
Trims whitespace around the given value
 
Syntax:
Replaces patterns matched by a regex with a replacement string
##TRIM(<token or value>)##
 
Example:
##TRIM("   Hello World   ")##
returns "Hello World"
 
=============================
 
REPLACE
Replaces all occurrences of a given string within the given token/value
 
Syntax:
##REPLACE(<token or value>,<search token or value>, <replacement token or value>)##
 
Example :
##REPLACE("Hello My World","My","Your")##
returns "Hello Your World"
 
=============================
 
LEFT
Returns the first 'n' characters of the given token/value
 
Syntax:
##LEFT(<token or value>,n)##
 
Example :
##LEFT("Hello My World",7)##
returns "Hello M"
 
=============================
 
RIGHT
Returns the last 'n' characters of the given token/value
 
Syntax:
##RIGHT(<token or value>,n)##
 
Example :
##RIGHT("Hello My World",5)##
returns "World"
 
=============================
 
SUM
Returns sum of all arguments - can pass arbitrary number of arguments
If any argument is not a number, will log an error
 
Syntax:
##SUM(<token or value>,<token or value>,<token or value> ...)##
 
Example :
##SUM({{lead.Lead Score}},5,10)##
returns 25, assuming Lead Score was 10
 
A
Anonymous
October 9, 2014
Hello Breno,
thank you for this post. I've been trying to search articles about these functions etc. but havent' been lucky with that, could you send a link to this ? I haven't found that here and not even on the developers.marketo.com.
Thank you,

Vaclav
D
David_Klein5
Level 1
March 12, 2015
Do we have to do anything to enable these functions?  When I attenpt to use the SUM function I get an error "Not a valid integer"?
Grant_Booth
Grant_Booth
Level 9
April 20, 2015
The functions Breno referred to were part of a beta product, which is not available to customers. I'm not certain it was ever generally available, and I think Breno may not have realized this. I don't think there's an out-of-the-box solution for this, and it would require using javascript to set a variable and then manipulate it before displaying. I'm not certain how to do this as it's outside my expertise, but I assume it can be done.
A
Anonymous
April 21, 2015
Hi Grant,
I see that the response Brono wrote is more than a year old, is there some estimate when this feature would go live ??? Currently we're solving this problem with webhooks going outside where is some processing, but that takes a long time and needs a publicly available machine.
 
Terms & ConditionsAccessibility statement

Loading footer...