Note: The scenario below uses data from the DESelect Demo Data Package.
Scenario: You have a data extension (Contacts) with contacts that you want to add to an existing list of contacts. When you add the new contacts you also want to add the date each record was added to the list at the local time zone to which they belong (e.g. CEST).
Note: This scenario uses feature Custom Values, which is available in DESelect Plus and Advanced.
1. Selection Criteria
On the selections overview screen, click on New to create a new selection.
Drag data extension DESELECT_DEMO_Contacts to the Selected Data Extensions section.
2. Target Data Extension
Hit the Create Data Extension button, enter a name, e.g. Contacts Target, and press Save.
On the section on the left click on Add all fields.
Birthday again by either double-clicking on it or dragging it to the section on the right and rename it to Contact Added.
Click Save Data Extension.
Click on the Delete icon next to the Birthday field that's mapped to Contact Added.
We have now created an extra field in our target data extension that we want to populate with the current time and date in Central European Standard Time (CEST) time zone. This field is not mapped to any fields in the source data extensions.
Now we're going to add a Custom Value:
- Under Custom Values on the left, click Add new value.
- Under Name, enter: Contact Added and hit Next.
- Choose Type: Apply formula to a field.
- Choose Type: Timestamp.
- Select Date + Time radio button below Format label.
- Click on Convert timezone toggle button to enable time zone convertion.
- Select Central European Standard Time (CEST) from the Convert to timezone drop-down list.
- Hit Save.
The logic defined above will, for each row, generate the current date and time and convert it to Central European Standard Time (CEST) time zone.
Now that the custom value Contact Added has been created, we can map it to the field Contact Added by drag-and-dropping it from Custom Values to the Contact Added mapping field.
When you click Run Preview on the Preview screen, a results table will be shown with fields:
- All fields from DESELECT_DEMO_Contacts
- Contact Added, populated with the current date and time in Central European Standard Time (CEST) time zone.