Note: The scenario below uses data from the DESelect Demo Data Package.
Scenario: You want to get the Orders that were placed in the last 6 months.
Watch the video tutorial on how to implement this scenario or follow the steps below.
1. Selection Criteria
On the selections overview screen, click on New to create a new selection.
Drag data extension DESELECT_DEMO_Orders to the Selected Data Extensions section.
Drag field Date to the Selected Filters section:
- Criteria: Greater Than or Equal To
- Select: Relative
- Value: 6, Months, Before Now
2. Target Definition
Hit the Create Data Extension button, enter a name, eg. Orders From Last 6 Months, and press Save.
Select the following fields by either double-clicking on them or dragging them to the section on the right:
- Id and Date from DESELECT_DEMO_Orders
Click Save Data Extension.
When you click Run Preview on the Preview screen, a results table will be shown with fields Id and Date from DESELECT_DEMO_Orders.
The results table shows only Orders from the last 6 months. Note we did not enter an exact date; whenever we run this selection, we'll always get Orders from the last 6 months as the date comparison is dynamic and based on the time of execution of the query.