Month and Date only

  • 9Views
  • Last Post 20 February 2019
0
votes
SAGU Web posted this 19 February 2019

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 20 February 2019

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