4. Select Orders from the last 6 months

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. Input

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. Output

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.

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.