You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Step-By-Step Guide To Extract Month From Birthday Date using Contact Washing Machine App and RegEx E

Received Response
in Eloqua 3 comments

Let's say you collect Birthdays of your customers in format Year-Month-Date and you wish to isolate the "Month" in another contact field called "Month" for some custom emails to be sent month-wise. Below is the step-by-step guide to extract just Month from Birthday (Format: Year-Month-Date) using Contact Washing Machine and RegEx, please be mindful of testing the CWM configuration in sandbox first.

  1. Create a contact field named – MONTH per say in your instance.
  2. Drag and drop Contact Washing Machine(CWM) app in a new Campaign from action bar
  3. Double click on CWM app and click on pencil icon.
  4. Enter below steps on Configuration window. Please Select, Step name, Source Field as your date of "Birthday" (Format: Year-Month-Date) contact field,  “RegEx Extract” under Action Item and enter code “[-.\/](\d+)[-.\/]” and Destination field as "Month" in this case.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!