4. Select Orders from the last 6 months

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: 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 Date from DESELECT_DEMO_Orders

Click Save Data Extension.

3. Preview

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.