Note: The scenario below uses data from the DESelect Segment 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 Selection to create a new one.
Drag Data Extension DESELECT_DEMO_Orders to the Selected Data Extensions section.
Drag field Order Date to the Selected Filters section:
- Criteria: Is after or on
- 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 Order 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.