Month and Date only

  • 4Views
  • Last Post 4 weeks ago
0
votes
SAGU Web posted this 4 weeks ago

Is there a way through expressions to only retrieve only the month and date?

Currently mailchimp on the birthday field only takes month and day, while the field I'm importing is the full date with mm-dd-yyyy.  Mailchimp birthday only wants mm-dd

1
votes
Mariia Zaharova posted this 4 weeks ago

You can try using Expression mapping for this.

For example, if all the data in the Birthday column in your CSV file comes with this format - '20-01-87' (dd-mm-yy), you can try using Expression like this one:

SUBSTRING(Birthday,FINDSTRING(Birthday,"-",1)+1,2)+"/"+SUBSTRING(Birthday,1,2)

  • Supported by
  • SAGU Web
Close